Subject How to do a full text search ?
Author nathanelrick
Hello,

We have a table where user can do classic search against different field

select
...
from
tableA
where
field1>n and
field2=i;

now i want to permit user to also filter by keyword
something like

select
...
from
tableA
where
field1>n and
field2=i and
(FieldVarcharDescr like '%Keyword1%' or FieldVarcharDescr like '%Keyword2%')

How to do this ?