Hi,

I have come across a challenge (for me at least) that I need to make an SQL Query by using all possible combinations of typed words to find the right records.

For example, the DB field contains the following:
HILTON WASHINGTON, 1919 CONN AVE., NW, DC., 20009

The user might search for:
hilton conn ave
hilton NW dc
hilton washington
etc.

I wanna to put all possible combinations into SQL query using 'OR' so that the user gets the right result.

Any idea how to implement this or any other good idea for the search criteria will be appreciated..

u can do this by procedure and make ur query dynamic.