I always put query clauses in the same order and format queries the same way. It makes them easier to read.
>I thought it was a valid WHERE. And I have used it before. The problem turned out to be that I had WHERE after ORDER clause. In VFP it never caused any problems and then I remembered that SQL Server is more stringent about the order of these clauses. So putting the clauses in proper order solved the problem.
--sb--