in reply to Unusual sorting requirement
Have you considered normalizing your data so you don't have to deal with rows of two different formats both here and again down the line?