Hi,

I have come across a challenge (for me at least) that I need to split an SQL search string into words and make all combinations of those.

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..