Helen,

>>SELECT * FROM RDB$DATABASE
>>WHERE 'AAA ' LIKE 'AAA'
>>
>>does not yield any result,

H> Here, 1.5 RC 6 on Win2K, this yields one row.

Here, 1.5 RC 6 on WinXP, this does not return any row, and that's
correct behaviour (see Ann's reminder).
It's odd you get one row from the same version of Firebird. Perhaps
some configuration issue?

BTW, LIKE does not require wildcards, it's just that using them is a
more common usage pattern than not using them.

Ciao
--
Nando mailto:nandod@...