Hi All,

I have a table which has several fields and one field is 'Keywords' which hold values to search records, for example, if one record has Keywords such as (Bank, Report, NBFI) and 2nd as (Bank, NBFI, Credit). I am using Access (Like operator) and ASP to fetch data on user typed keywords. So if user input 'Bank' as search keyword. It displays both records but if a user input (Bank, NBFI) it only fetches 2nd record. It doesn't show both records.

Can any one help me where am I wrong?

Thanks