SEARCH result

[weezerboy]

I have a column in my database that has values like this

Row1 : RA1,RA2
Row2 : XA1,XA2

I have a search form that will pass a value and query the table.

If the user enters RA1 I need the search to return row 1, it doesnt now

When I run the search query the result for row 1 is 'RA1,RA2' so unless my user enters in RA1,RA2 no result is returned.

I need a result returned if the user enters any of the values in the list not all of the values in the list.

How would I do this

[Dan_Bracuk]

The answers in this thread, http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=3&threadid=1413960&ente... are relevant to your dilemma.