>Is it VFP? If yes, you may use NVL function. You may also use numbers in ordering ORDER BY 3,2 It will shorten the sql string a bit.
Yes, if it would have been in regards to optimization.
But, to go back to this issue, it is really annoying to get this kind of reaction from the provider. I really can't understand why this is happening.