General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only