I have three columns in a table called "Client". The three columns are

a) Client_Code
b)Name
C)Interests

A particular client can have multiple interests,which I am storing in One column, eg Sports,Computers etc


I want to generate a report based on the interests. If Any of the interests of the client matches with the criteria given the Client Details should come in the Report.



I am using ADO and Crystal Reports.

HELP!!!!!