davebiscuits
IS-IT--Management
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.
(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.