Test with

select
...
from
tableA t
where
t. || :NameFile1 || like %'' || :keyword1 || %'' or t. || :NameFile2 || like %'' || :keyword || %''

Best Regards
=========
|| ISMAEL ||
=========

----- Original Message -----
From: nathanelrick
To: firebird-support@yahoogroups.com
Sent: Friday, March 23, 2012 10:12 AM
Subject: [firebird-support] How to do a full text search ?



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 ?





[Non-text portions of this message have been removed]