>>
>>Len,
>>Sorry but caught off guard :) I surrender.
>>Cetin
>
>Wasn't trying to catch you out, I just thought I was missing something. It does seem to be a possibly severe problem if the order of the expressions can have such an effect.
>
>I originally found the problem in Foxpro 2.5 & tried contacting Microsoft support - I used the above description of name/hair colour & was told by the support person that I obviously knew nothing of SQL & of course I should expect different results (this was also the same person who told me to remove the brackets/parentheses to see if it gave the correct results - I've just mentioned this on another thread).

I know, I meant I was stumped too:)
Hmm then according to MS person I'm in those knowing nothing about SQL too :)
Cetin