We have a table that has a number of different kinds of codes in it.
Some are numbers and some are not, so the code itself is defined as a
CHAR.

Is it possible to order the data numerically in a select statement
even when it isn't so the data comes out like:

1
2
3
11

instead of

1
11
2
3

Thanks in advance.

Todd Brasseur
COMPASS Municipal Services Inc.