>Hi Len
>I tried and got the same (unexpected!) results.
>I don't have a clear explanation, but removing TRIM I got the "expected" results, which may point to how SQL handles the length of the strings in the result data set?

Most disconcerting though is example 2, where I repeat the original integer comparison - there you wouldn't expect any change in the way things work.