Kevin,

I think the keyword highlighting in color is just from the UT editor. I typed the line in here and didn't cut and paste, but I have typed it multiple times both in VFP editor and in Query Analyzer. It always looks the same as it did here and it always fails. :-)

>The query looks fine to me - however, it struck me as odd that every keyword was in blue, except for the word 'order'.

>This may sound nutty, but was this code pasted from something where there might be a control character or something that isn't being displayed? I've had that happen a time or two, when I pasted code from an e-mail.
>
>If you retype the query from scratch, does it work? Again, just a wild thought.
>
>Kevin