c# - Converting user-entered search query to where clause for use in SQL Server full-text search -

What is the best way to change search terms by a user, which can be used in that query where complete Search for section table lookup and return relevant results? For example, the following query has been entered by the user:

  + "e-mail" + attachment - "word document" - "e-learning"  

Some should translate into:

  Select my location from (* (',' '' '' e-mail '') and (in (*, '' attachment '')) And ("document of word") and (not included (*, '' e-learning ''))  

I use one at this time I am using a regular expression which users can use Parses the query that is entered in the boxes, and then from where to the tokens it forms.

However, this is probably a general requirement by many systems using full text search, I am curious about how other developers have approached this problem, and what to do There is a better way.

It may not be exactly what you are looking for but this will give you some more ideas Can provide