SupplierID Query Help


S

Steve

I found this query in an old post.

SELECT SupplierID FROM Item WHERE ItemLookupCode'RDB8020301'

When I run it, I receive this error message:
An error occurred while executing query:

Line 1: Incorrect syntax near 'RDB8020301'.

Can anyone throw me a bone and let me know how to correct. Thanks

Steve
 
Ad

Advertisements

E

Evan Culver

SELECT SupplierID FROM Item WHERE ItemLookupCode='RDB8020301'

-
Evan Culver
New West Technologies
 
O

ozzie

Or even:

ItemLookupCode LIKE 'RDB8020301'



Evan Culver said:
SELECT SupplierID FROM Item WHERE ItemLookupCode='RDB8020301'

-
Evan Culver
New West Technologies
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top