How would I use SQL to filter results based on keywords?

I am trying to filter through results in a field called description. My sql statement is

SELECT * FROM PRODUCT WHERE [desc] LIKE '%blue%';

This should select any record that has the color blue in its description, but for some reason it will not work. Am I doing this right?
AlexanderMaxwellAsked:
Who is Participating?
 
lwadwellCommented:
Hi AlexanderMaxwell,

In a lot of dbms's yes.  In MS Access no. Try LIKE '*blue*' ... i.e. use * instead of %.

lwadwell
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.