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?