Subject Re: [firebird-support] is this firebird LIKE bug?
Author Helen Borrie
At 11:52 PM 22/10/2004 +0700, you wrote:

>Hello all,
>I found a strange condition with SELECT...LIKE in Firebird 1.5.1, I just
>want to confirm is this a bug or not.
>1. create table a (n varchar(50));
>2. insert into a values (' SONY-AK');
>3. run statement like this ---- select * from a where n like ' %'
>The result is very strange for me, it give me zero record set, is this a bug?

It works as expected here: it returns one row.

Did you commit the insert?