I like your first suggestion Rad. SPLIT should be much faster then a bunch of CASE statements.

The second version might not be that much of a time saver. My own personal preference is to get back the correct type and then I'll sort/edit in Excel if I want to show something in a report.