Ann Harrison wrote:

> At 05:12 PM 6/1/2003 +0200, Paul Vinkenoog wrote:
> > >
> > > 1
> > > 11
> > > 20
> > > A
> > > AA
> > > BA
> > >
> > > ??
> > >
> > > What kind of order is this? This is a very custom order...
> >
> >I think "the right order" is what the user/programmer needs at a
> >certain point in the application, so it varies from case to case.
>
> You might want to look at some of the information at ibphoenix.com
> or http://www.brookstonesystems.com/ on collations. Essentially a
> collation is a mapping from the user representation of data to a
> representation that sorts naturally. In your case, all that would
> be necessary, I think, is to pad all numeric values with leading
> zeros out to a common length. Any key with a leading number (29B)
> would count as numeric.

My stored procedure seems to work. I am populating a double precision
column with data from the char column. I check each character before
adding it to the double precision column. Actually I add them to
another char column and then do a cast at the end of the procedure.

Todd

>
> Regards,
>
>
> Ann
>
>
>
> Yahoo! Groups Sponsor
> <http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705115386:HM/A=1564416/R=0/SIG=11ti81skc/*http://www.netflix.com/Default?mqso=60164797&partid=3170658>
>
>
>
> 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/>.

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