Is there a way of doing a conditional sort along the lines of:
If field x is not empty sort this record using fields x & y, else sort using fields z & y ?
What I want to do is sort fields alphabetically which begin with numbers by using their text equivalents (eg. 10 ABC sorts as Ten ABC) by using a second field with the text equivalent. This would account for <1% of my records so I'd like to avoid a complete duplication of my sort field merely to accommodate those few records.
Thanks for any insight you can provide.