Mark, You're right. My brain was asleep. I've been using OR. Had never tried AND.
Karol, Thanks for clarifying. ```````````````````````````` On Sat, Nov 30, 2019 at 5:10 AM Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > >>Not sure what pattern is. > > > > Pattern replace unknown leter(s) sumbols are „%” multiple letters, „_” > single letter > > e.g. > > ‘Ne%flix’ will find Neflix, Netflix, Netxxxxflix …. > > > > >>I prefer the word LIKE. Is easier to avoid errors vs. using '='. Are > there advantages to using '='? > > > > If you use like with param Firebird cannot use index on field firstName or > e.g. expression index Upper(firstName) > > > > As your param have unknown value. It can be ‘Netflix’ or ‘%Netflix’, or > whatever > > But if you use „=” it simply can use index if such exists. > > > > Regards, > > Karol Bieniaszewski. > > >
