>Len,
>
>Courtesy of Anders Altberg, SET ANSI ON will give the same results for each pair of queries.
>

Unfortunately not the expected ones, i.e. ABCD=ABC should be true - but that can be worked around.

Its very disturbing how swapping the order of the integer comparisons or duplicating an integer comparison affects the result set.

Should select only be used with SET ANSI ON to get reliable results ?