Hi,

> 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'

What kind of columns is "Field1" - is it a CHAR or VARCHAR column?

> 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.

Does "Field1" have values with trailing spaces?


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com