Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    32

    Unanswered: Making SQL Query by Using All Possible Combinations of Given Words

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

  2. #2
    Join Date
    Jul 2011
    Posts
    38

    dynamic query

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •