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
Karol Bieniaszewski [email protected] [firebird-support] Fri, 29 Nov 2019 10:41:20 -0800
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