ODP: [firebird-support] What key word specifies a search for an entire word?

2019-11-30 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] 
>>Not sure what pattern is.

Pattern replace unknown leter(s) sumbols are „%” multiple letters, „_” single 
letter
e.g.
‘Ne%flix’ will find Neflix, Netflix, Netflix ….

>>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.

ODP: [firebird-support] What key word specifies a search for an entire word?

2019-11-29 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support] 
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