>>>You clever b......!
>>>
>>>Excellent, thanks for that.
>>>
>>>Kev
>>
>>I only got there first because there's no one else on line! - Just wait until America wakes up you'll probably get 20 better suggestions!
>Snooooore, yaaaawwwwn, (belch) hmmm. You could also try SELECT whatever, field1, EMPTY(field1) AS isitempty FROM yourtable INTO CURSOR yourcursor ORDER BY isitempty, field1 DESC. Maybe you also need isitempty DESC but I haven't tried it. Anyhow, it might go faster than a UNION SELECT.

<vbg>