Subject Why "Like" , "=" return diffent number records?
Author Kadee
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