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:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.