Hi All,

I am trying to build a smart query builder for my ASP/SQL application that is using a full-text index. I am using CONTAINSTABLE for all the queries so I can use the rank.

Q: Without making the SQL statement dynamic in the database, what is the best to get all the results based on any search condition the user may pose?

Q: Would it be best to write a stored procedure for each type of possibility and call that SP based on the users query?

For example:

SP 1: "free email"
SP 2: ISABOUT("free email" weight(1), free weight(.2), email weight(.1))
SP 3: "free email" OR "free NEAR email"

Thanks for any tips...
Mike