Order by the length of the field, then the field itself.  This won't
always work if there are overlaps.

--Ben Doom

Rick Faircloth wrote:

> Hi, all...
>
> How can I order these values numerically?
>
> 1:1-5
> 1:14-18
> 1:6-8
>
> How can I, without making the db field a numeric field rather than a varchar
> field,
> cause these values to be ordered this way:
>
> 1:1-5
> 1:6-8
> 1:14-18
>
> Thanks for your help...
>
> Rick
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG Anti-Virus (http://www.grisoft.com).
> Version: 7.0.241 / Virus Database: 262.10.2 - Release Date: 5/18/2004
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to