SQL Select question

[megalith]

I'm trying to figure out how to get my search results more specific and am
having trouble figuring this out. With the example code below if a user
searches for "hawk" they will get '0' results even though "hawk" is in a comma
delimited list in the "keywords" column of the DB (Access). If I use the
"LIKE" operator on the Keywords column then "hawk" will come up in the results
but will also include "hawkweed" which I don't want.

Is there another way I can write this so that a search for "hawk" will find
the exact match in the comma delimited list of keywords?

Thanks in advance.

<cfquery name="GetResults" datasource="#Datasource#">
SELECT *
FROM Images
WHERE (ImageName LIKE '%#SearchString#%'
OR Category LIKE '%#SearchString#%'
OR ImageComments IN ('#SearchString#')
OR ImageKeywords IN ('#SearchString#'))
ORDER BY SortOrder
</cfquery>


ImageKeywords List
Saw-whet owl, saw whet owl, northern bird, owl perched in tree, Aegolius
acadicus, carnivore, raptor, bird of prey, noctural, predator, wildlife at
night, life, owl rotating head, owl turning head

[philh]

"hawk" is in a comma delimited list in the "keywords" column of the DB
(Access).

There's your root problem.

The "correct" solution to this problem is to properly relate records to
keywords in a many-to-many construction. This requires re-designing the
database.

Good luck.

[megalith]

thanks Phil