At 08:12 AM 8/10/2003 +0000, you wrote:

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

LIKE needs a wildcard:
try
select * from Tableq
where field1 like 'AAA%'

or try
select * from Tableq
where field1 starting with 'AAA'

h.