Hi I have a column in my database where emails are copied to, and i need

to be able to search through each entry for certain keywords and display the

results if the column contains any of the keywords. i can't figure out how to do

this though, because if i use the select statement like this:

select * from maintable where column LIKE ('keyword')

or

select * from maintable where column IN ('keyword')

it will only display the results when the keyword is the only word in the field. Can anyone help?

Dear its mean you like the search where nothing is mathc. Think here when a user search for the key word the system should give him the result of his search nothing else. Other wise you may display the results what you want to display


(*_*)


Numan
--------------------------------------------------
Love is the most precious thing of this world. So find and grab it!

i'm sorry i don't understand what you mean? can you explain again? thanks again!

You need to add wildcard char to your keyword (* for Access or % for SQL Server):
select * from maintable where column LIKE ('%keyword%')

If you have more than one keyword you need to use OR:
select * from maintable where column LIKE ('%keyword1%') OR column LIKE ('%keyword2%')