Subject | is this firebird LIKE bug? |
---|---|
Author | Sony Arianto Kurniawan |
Post date | 2004-10-22T16:52:20Z |
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
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