This might be a pretty basic question, I am fairly new to this stuff:

Is there a way to set the ORDER BY to start at a different location than the beginning of the alphabet? I would like to sort the results by a column called 'office' but have the first results start with the letters 'DR' then move through the alphabet ending with rows that have 'DQ' in the 'office' column.

Is there a way to put a formula in the ORDER BY directive?
Thanks anyone who can help.