On 29-11-2019 22:52, Clyde Eisenbeis [email protected] [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
