Oracle Order By Problem 1

[DanAuber]

I'm sure this isn't the first time this has been asked.

If I order by a certain column - varchar but holding numbers I get 2,20,21,22 rather than 2,3,4,5. Is there a quick way around this in the order by clause ?
Dan Auber



Dan Auber

 

[KenCunningham]

Can you use to_number? As in:

to_number (string1, [format_mask], [nls_language] )

string1 is the string that will be converted to a number.

format_mask is optional. This is the format that will be used to convert string1 to a number.

nls_language is optional. This is the nls language used to convert string1 to a number.

HTH.