Thanks to your help;

I use sybase ASA,ASE,
these 2 SQL statement("like","=")
always return same Result(all 150 recordcount);

Why doesn't FB act like Sybase?

Kadee Aon.

>
> LIKE needs a wildcard:
> try
> select * from Tableq
> where field1 like 'AAA%'
>
> or try
> select * from Tableq
> where field1 starting with 'AAA'
>
> h.