Leyne, Sean wrote:

> The results are correct because the SQL Standard defines trailing spaces
> as not significant for comparison purposes, regardless of the comparison
> type (Like or =) or whether the column is defined as a CHAR/VARCHAR.

I thought like did consider trailing spaces to be significant. Is this
incorrect?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64