[Cialug] Alphabetical Sort

[Kenneth Younger]

Which flavor of SQL are you using?


On Wed, Dec 11, 2013 at 5:35 PM, Patrick Mcgillan <
patrick.mcgillan at gmail.com> wrote:

> I have this problem where a SQl field contains characters like this in
> different records.
>
> 1.4.1
> 1.4.10
> 1.4.2
> 1.5.1
> 1.5.10
> 1.5.11
> 1.5.12
> 1.5.2
> 1.5.3
> Trouble is, 1.4.2 should sort out before 1.4.10, but because it is a
> character field it doesn't. Now that makes perfectly good sense to me, but
> not the customer. I can't sort on ID as the entries are randomly done. I
> sense that this problem has been solved before, but can't put my finger on
> it.
>
> Can anybody point me in the proper direction.
>
> Patrick
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug
>
> --
> Kenneth Younger III
> Founder, Sheer Focus Inc.
> e: kenny at sheerfocus.com
> p: (515) 367-0001
> t: @kenny <http://twitter.com/kenny>
> <http://cialug.org/mailman/listinfo/cialug>
>