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

[Clyde Eisenbeis cte...@gmail.com [firebird-support]]

Not sure what pattern is.  If I am searching for two words I use OR or
AND.

"SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower( @p0
) AND lower(fstName) LIKE lower( @p1 ) "

I prefer the word LIKE.  Is easier to avoid errors vs. using '='.  Are
there advantages to using '='?

```````````````````````````

On Fri, Nov 29, 2019 at 12:40 PM Karol Bieniaszewski
liviusliv...@poczta.onet.pl [firebird-support] <
firebird-support@yahoogroups.com> wrote:

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