RE: Sorting "character" numbers

Yes it would... very interesting solution!

Brad

> -----Original Message-----
> From: boothm@earth.Goddard.edu [mailto:boothm@earth.Goddard.edu]
> Sent: Tuesday, June 06, 2000 6:39 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: Sorting "character" numbers
> 
> 
> Brad, I ran into this once. Consider this solution:  "For 
> plant controls 
> we would like each plant to have it's own series of numbers.  We are 
> assigning invoice number blocks for each (region,plant,division) as 
> follows: Your facility will use 10-digit numbers beginning with 1250 
> through 1259.  Your block of numbers is 1250,000,000 through 
> 1259,999,999."
> 
> Then you see there is no leading zero problem.  <vbg>
> 
> hey, it'd work wouldn't it?
> _______________________
> Booth Martin
> booth@martinvt.com
> http://www.MartinVT.com
> _______________________
> 
> 
> 
> 
> "Stone, Brad V (TC)" <bvstone@taylorcorp.com>
> Sent by: owner-midrange-l@midrange.com
> 06/06/2000 02:51 PM
> Please respond to MIDRANGE-L
> 
>  
>         To:     "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com>
>         cc: 
>         Subject:        Sorting "character" numbers
> 
> I'm sure someone has run across this before.
> 
> We have a DB that contains a character field which holds an invoice 
> number.
> Because it can be used for many of our companies, we had to make it
> character because some of our companies use character invoice numbers.
> 
> Anyhow, the plants that use numeric numbers get the number stripped of
> leading zeros (this is done automatically by the replication 
> tool we use).
> So, it makes the number sort all funky.  (ie 900 is greater 
> than 1101.)
> 
> Is there any way, without having to leave on leading zeros, 
> to get them to
> sort correctly?  Probably not, but with the minds on the list 
> I wouldn't 
> be
> surprised.  ;)
> 
> Brad
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
> 
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---