On Sat, Nov 30, 2019 at 5:10 AM Karol Bieniaszewski liviuslivius@... [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.