order by numerically?

[davebiscuits]

SELECT house_number from house order by house_number asc;" gives me:

(house_number is of character varying type)

1
11
1A
2
222
2A
3
33

How can I get this to order my results numerically?

I tried "SELECT house_number from house order by house_number::text::integer asc;" but it doesnt like my "1A" or "2A" entries.

Any thoughts?

Thanks in advance,
Dave.

 

[DotNetGnat]

Try this:

"SELECT house_number from house order by value(house_number) asc;"

-DNG