2 Replies Latest reply on Jul 20, 2006 6:36 AM by drforbin1970

    Expanding Search Functionality ??

    jimmy.hunt Level 1
      Hello,

      I have a table that has a column for a title and a column for description. I want to create a search functionality that will allow a user to enter in a string and click submit to search through both the title and description columns.

      I have a generic sql query:

      ...where title LIKE '%#txtSearch#%' or description LIKE '%#txtSearch#%'

      to get results right now. I'd like to extend my searching to allow a user to enter multiple words that don't have to be in perfect sequence to get a result. Does any one have any ideas on how to do this?

      Thanks!
      James