Need to know if this is possible and how to execute
colA and colB are similar datatypes (phone number for example)
SELECT colA from TABLE where id>0 ORDER BY colA
but if colA data is NULL use colB and optionally have it sortable.
something like this may explain my thoughts better...
SELECT colA,colB AS colA if colA IS NULL from TABLE where id>0 ORDER BY colA