Well, the Full Text Search is a new feature for advanced database
searching, it is more powerful than normal SQL (contains new operators
such as "contains" and allow end-users commands like "OR" and "AND".
Sounds good, but the problem is the indexing, is quite slow (even the
incremental one). But when the indexes are created the performance is very
fast.

To run a dynamic SQL from a Stored Procedure, do the following:
Declare @sql1 varchar(255)
Declare @sql2 varchar(255)

select @sql1 = "Select * from <tables> where "
select @sql2 = @a_Where_Clause

Exec (@sql1 + @sql2)

Good luck !!!

Geoffrey Chu