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%';

Answers


Try this

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

Need Your Help

How to get a random number between a float range?

python random floating-point

randrange(start, stop) only takes integer arguments. So how would I get a random number between two float values?