Select Statement using Like

S

sjn78

Well-known member
Joined
May 4, 2003
Messages
255
Location
Australia
I am having some troubles performing this select statement.

This is what access produces:

SELECT Photos.Keywords
FROM Photos
WHERE (((Photos.Keywords) Like "*red*"));


This is where I am but getting no results.

"SELECT Keywords From Photos WHERE Keywords Like * & keyword.text & *"

Could someone have a look and see where I am going wrong.

Thanks

Steve
 
instead of using the astrix use percentage

Code: 
SELECT Photos.Keywords
FROM Photos
WHERE (((Photos.Keywords) Like "%red%"));

Andy
 
Back
Top