| Subject | Re: [firebird-support] What key word specifies a search for an entire word? |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2019-11-30T07:19:45Z |
On 29-11-2019 22:52, Clyde Eisenbeis cte677@... [firebird-support]
wrote:
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
wrote:
> The fstName is the column title, not the value. I'm using embeddedThat you're using Firebird Embedded doesn't matter, it works exactly the
> Firebird.
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