Separating an indeterminate number of words and searching on them
Posted on 2011-02-10
I have a form with a keyword search box (there are other things that are included in the search on the form ... checkboxes and such).
The keyword search box instructs users to enter one or more search terms separated by commas. How can I (in code) take apart the search string (without knowing really how long it is)... at the comma, remove the spaces, and search a table ("MyTable") for each term? (I have a radio button that allows users to select "AND" or "OR" and I'll incorporate that info into the query i build in code).
Thanks for your help.