See TextSearch stored procedure for information, as well as:
select ...from ... where ...
The where-clause (belonging to a from-clause referencing the table, or view the index was created on), must contain "<keycolumn> in (%s)" in a place where SQL allows an IN-predicate.
The statement has following structure for ranked queries (ranking-Flag=1):
select ...from ... where ...The select-clause must contain a column-reference "RSCORE" in a place where SQL allows an expression. The from-clause must contain a "%s" where SQL allows a table-reference. The where-clause (belonging to a from-clause referencing the table or view the index was created on), must contain "%s" in a place where SQL allows an IN-predicate.