Select Statement using Like

[sjn78]

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

[a_jam_sandwich]

instead of using the astrix use percentage

 

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

 

Andy