>>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.