CODEWITHSUNDEEP
sqlms-access
Tim
Tim

Reputation: 331

SQL Access Query like expression not working

I'm trying to test a query using 'like' but i'm not getting any results back. I tried using UPPER() but when I executed the query, access said that UPPER was undefined?

SELECT ITEM.Category, ITEM.Description
FROM ITEM
WHERE ITEM.Category LIKE '%Plate%';

Upvotes: 0

Views: 3533

Answers (1)

Damith
Damith

Reputation: 2082

Try this 

    SELECT ITEM.Category, ITEM.Description
    FROM ITEM
    WHERE ITEM.Category LIKE '*Plate*';

Upvotes: 3

Related Questions