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

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