Subject is this firebird LIKE bug?
Author Sony Arianto Kurniawan
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?

I've reproduce above steps in MS SQL Server and it works fine.

Thanks.


--
Sony AK
The Sony AK Knowledge Center - www.sony-ak.com - share it freely
Yahoo! Messenger: sonyarianto