Why like '%'

Don´t think that it is the same any WHERE ?

OR......

i DO NOT UNDERSTAND YOU.


On Fri, 22 Oct 2004 23:52:20 +0700, Sony Arianto Kurniawan
<sony@...> 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?
>
> 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
>
>
>
> Yahoo! Groups Links
>
>
>
>
>