[Cialug] Alphabetical Sort

[Kenneth Younger]

It would depend on your version how you would want to tackle it. I hope for
simplicity sake you are using 2008 :)

http://stackoverflow.com/questions/3474870/how-can-i-sort-a-version-number-column-generically-using-a-sql-server-query


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

> ms sql and asp web pages
>
>
> On Wed, Dec 11, 2013 at 6:55 PM, Kenneth Younger <kyounger at gmail.com>
> wrote:
>
> > 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>
> > >
> > _______________________________________________
> > Cialug mailing list
> > Cialug at cialug.org
> > http://cialug.org/mailman/listinfo/cialug
> >
> _______________________________________________
> 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>
>