On Wed, 19 Oct 2005, Dann Corbit wrote:
> Yes, clearly that is the wrong result according to the SQL standard.
>
> Here is a SQL*Server query:
> select 1 where 'a' = 'a ' AND 'a' = 'a ' AND 'a ' = 'a '
>
> It returns (correctly): 1
Doesn't that depend on the collating sequence in use, or is a NO PAD
collating sequence not allowed here?
