> 'AAA' like 'AAA ' is not a match, but 'AAA%' like 'AAA ' is a
> match.

Correct, but his findings also reveals something more:

SELECT * FROM RDB$DATABASE
WHERE 'AAA ' LIKE 'AAA'

does not yield any result, whereas

SELECT * FROM RDB$DATABASE
WHERE 'AAA ' = 'AAA'

returns one row. Though he is on 1.0.0.796 and I only tested on 1.0.2.
908 (I have not installed 1.5 yet), so this may be changed in later
releases. Or am I wrong in my understanding of how things should be?

Set