Subject Re: [firebird-support] is this firebird LIKE bug?
Author Helen Borrie
At 08:01 PM 22/10/2004 -0400, you wrote:

>Why like '%'

It wasn't like '%' but like' %' - it has a leading blank.

> 2. insert into a values (' SONY-AK');
>
> 3. run statement like this ---- select * from a where n like ' %'


>DonĀ“t think that it is the same any WHERE ?
>
>OR......
>
>i DO NOT UNDERSTAND YOU.

He wanted to return rows where the value started with a leading blank. (A
leading blank is a character). It behaves correctly for me.

./hb