SQL LIKE command

[CasitaProgrammer]

I am trying to use the LIKE to find the word green in any product name

The Table is PRODUCTS and column is ProductName
What I entered:
SELECT * FROM PRODUCTS
WHERE ProductName LIKE "%green%";

It doesn't work and I know that there are products that have green in the ProductName

What am I doing wrong?

 

[vbaInet]

Replace % with *

 

[CasitaProgrammer]

Thanks, I had tried different variations for an hour and you solved the problem in seconds.
Thanks