Not sure what pattern is. If I am searching for two words I use OR or AND.
"SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower( @p0 ) AND lower(fstName) LIKE lower( @p1 ) " I prefer the word LIKE. Is easier to avoid errors vs. using '='. Are there advantages to using '='? ``````````````````````````` On Fri, Nov 29, 2019 at 12:40 PM Karol Bieniaszewski [email protected] [firebird-support] < [email protected]> wrote: > > > Do you use pattern or simple string? > > If it is simple string then better is using „=” instead of like. > > > > "SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) = lower( @p0 )" > > > > Regards, > > Karol Bieniaszewski > > >
