A proc for each query type gets my vote. This way, you can optimize the specific search.
-Mike
>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