SQL: numeric sort of a varchar field

From: <eric.lecocq@xxxxxxxx>
Date: Tue, 22 Jan 2008 12:15:07 +0100

Hello Everybody,

my question is the following. how can sort numerically a sql query with varchar field ?

thank you for your help.

ELE.

EG. sort a list of bus lines

1
14
2
23
3
4
44
5

must be

1
2
3
4
5
14
23
44

.

Follow-Ups:
- Re: numeric sort of a varchar field
  - From: Paul Shapiro

Prev by Date: Re: Using Developer Licence for Dev and Test Servers
Next by Date: Re: numeric sort of a varchar field
Previous by thread: Re: Using Developer Licence for Dev and Test Servers
Next by thread: Re: numeric sort of a varchar field
Index(es):
- Date
- Thread