Subject | Why "Like" , "=" return diffent number records? |
---|---|
Author | Kadee |
Post date | 2003-10-08T08:12:26Z |
Dear Sir;
I use Firebird-1.0.0.796-Win32, and
I got a weird stuation:
When I execu SQL as
select * from Tableq
where field1 = 'AAA'
the recordcount of result is 150 .(correct result)
but if I use SQL as
select * from Tableq
where field1 like 'AAA'
the recordcount of result only 125.
some record seen disappeared.
Please Help me and forget my poor english.
Kadee Aon
I use Firebird-1.0.0.796-Win32, and
I got a weird stuation:
When I execu SQL as
select * from Tableq
where field1 = 'AAA'
the recordcount of result is 150 .(correct result)
but if I use SQL as
select * from Tableq
where field1 like 'AAA'
the recordcount of result only 125.
some record seen disappeared.
Please Help me and forget my poor english.
Kadee Aon