>>BTW, why do you use UPPER() in the ORDER BY? Is this column case sensitive?
>
>No, it's not. But, this is part of the framework and is generic to support VFP and other types of backend.

It's invalid for VFP because VFP does not support expressions in the ORDER BY.
It's unnecessary for SQL Server if column is case insensitive.