Would it be possible to do an ORDER BY on the last word of a field? For instance, if I were using a corporation name field it would sort like:
'Radio Shack, AL'
'Best Buy, AZ'
'Radio Shack, CO'
'Best Buy, RI'
'Radio Shack, IN'
instead of:
'Best Buy, AZ'
'Best Buy, RI'
'Radio Shack, AL'
'Radio Shack, CO'
'Radio Shack, IN'
or is it required to create a separate field for the word I want to sort by? There really isn't a reason other then the ORDER BY command why I would want to create another field, so I would like to use another method.
'Radio Shack, AL'
'Best Buy, AZ'
'Radio Shack, CO'
'Best Buy, RI'
'Radio Shack, IN'
instead of:
'Best Buy, AZ'
'Best Buy, RI'
'Radio Shack, AL'
'Radio Shack, CO'
'Radio Shack, IN'
or is it required to create a separate field for the word I want to sort by? There really isn't a reason other then the ORDER BY command why I would want to create another field, so I would like to use another method.