Title: Like operator bug?
Maybe my SQL is getting rusty but here is what I have seen:
create table tt(cc varchar(10) null)
insert into tt(cc) values ('')
select count(*) from tt where cc like ''
==> 0 Rows returned !!! Is this a bug?
select count(*) from tt where cc = ''
==> 1 Rows returned
select count(*) from tt where length(cc) = 0
==> 1 Rows returned
I'm using v3.25.
Thanks,
Eivind Skildheim
Software Developer
Motive Communications, Inc
Austin, TX USA
|