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
SELECT SupplierID FROM Item WHERE ItemLookupCode='RDB8020301'
- Evan Culver New West Technologies
Or even:
ItemLookupCode LIKE 'RDB8020301'
"Evan Culver" wrote:
Thanks fellas, I'm back in business.
Steve O
"Steve" wrote:
Have something to add? Share your thoughts — no account required.
Ask the community — no account required