| Subject | Re: [firebird-support] What key word specifies a search for an entire word? |
|---|---|
| Author | Clyde Eisenbeis |
| Post date | 2019-11-29T21:32:02Z |
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 liviuslivius@... [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