Yes, tried that. no luck

Paul Vinkenoog wrote:

> Hello Todd,
>
> > We have a table that has a number of different kinds of codes in it.
> > Some are numbers and some are not, so the code itself is defined as
> > a CHAR.
> >
> > Is it possible to order the data numerically in a select statement
> > even when it isn't so the data comes out like:
> >
> > 1
> > 2
> > 3
> > 11
> >
> > instead of
> >
> > 1
> > 11
> > 2
> > 3
>
> Have you tried it with a CAST? (Don't know if it works, never tried
> using a CAST within an ORDER BY myself.)
>
> Greetings,
> Paul Vinkenoog
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
> Click Here!
> <http://rd.yahoo.com/M=244522.3313099.4604523.1261774/D=egroupweb/S=1705115386:HM/A=1595056/R=0/SIG=124fv1soh/*http://ashnin.com/clk/muryutaitakenattogyo?YH=3313099&yhad=1595056>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.

--
Todd Brasseur, A.M.A.A.
COMPASS Municipal Services Inc.




[Non-text portions of this message have been removed]