# \#sql-lookup

**URL:** https://community.cdata.com/tag/sql-lookup/496.md

[Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md)

---

## [Problem using Lookup](https://community.cdata.com/t/problem-using-lookup/817)

<div class="topic-metadata">

**Author:** [@russell-jerseypost](https://community.cdata.com/u/russell-jerseypost)\
**Replies:** 3\
**Last updated:** [July 25, 2024, 6:29am UTC](https://community.cdata.com/t/problem-using-lookup/817 "2024-07-25T06:29:59Z")

</div>

CData Arc™ 2023 - 23.4.8789.0 I’m trying to use a SQL Server Lookup to determine if a matching record exists or not Here are my settings If I use “Use NULL Value” I do not get the Lookup-consignmentno …