At 11:24 AM 8/10/2003 +0000, Set wrote:

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

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

>whereas
>
>SELECT * FROM RDB$DATABASE
>WHERE 'AAA ' = 'AAA'
>
>returns one row.

Same.

As does this:

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

Would you test that one on 1.0.2? (though 1.0.3 would be more interesting,
since both of the versions below are superseded by 1.0.3)

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

h.