Win Web Hosting

The easiest way is to use the FREETEXT clause because it does not require a specifc format. The CONTAINS keyword allows you to use search limiters such as “AND NOT”. You will however need to create a full-text index on the table/columns you want to search.

Where are you outputting your results to? I’m assuming a .net webpage. If so you could simply just split your search string into parts. Use the ‘%LIKE%’ syntax for each separate word and then merge the results if you stored them in datatables by simply calling the Merge method of a datatable.