| Subject | Re: [firebird-support] What key word specifies a search for an entire word? |
|---|---|
| Author | Tjioe Hian Pin |
| Post date | 2019-12-02T10:06:01Z |
what about:
SELECT fstName, fiKeyID FROM Members WHERE ' '||fstName||' ' containing ' '||@po||' '
Cheers,
Tjioe
On Saturday, November 30, 2019, 02:20:00 PM GMT+7, Mark Rotteveel mark@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
On 29-11-2019 22:52, Clyde Eisenbeis cte677@... [firebird-support]
wrote:
> The fstName is the column title, not the value. I'm using embedded
> Firebird.
That you're using Firebird Embedded doesn't matter, it works exactly the
same as Firebird Server for queries. The problem is that your using two
conditions on column fstName using AND. That means for a single row both
conditions must be true for that column.
The conditions
lower(fstName) LIKE lower(@p0)
AND lower(fstName) LIKE lower(@p1)
will only be true if both @p0 and @p1 can match the same value, which I
think is unlikely for a column which contains first names. Maybe you
meant OR instead?
Mark
--
Mark Rotteveel