Can you confirm this? I would need hard proof. I appreciate the insight however.
Mike ----- Original Message ----- From: "Jason Lees (National Express)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 10:48 AM Subject: RE: numbers too big > Why 30 digits?, I'm not aware of any numbers of greater than 20 digits, even > with the International diaing code. > > Jason Lees > Development Team Leader > National Express. > > > -----Original Message----- > From: Michael Tangorre [mailto:[EMAIL PROTECTED] > Sent: 13 June 2003 15:25 > To: CF-Talk > Subject: numbers too big > > > I have some really large number ranges that I need to store in a SQL Server > 2K DB. > > The numbers are of the following size: > > range start > 000000000000000000000000000000 > > range end > 999999999999999999999999999999 > > That was one generic example. Basically the number represents a phone number > range and I have a range for each country in the world that has telephone > service. What would be the best way to store it these ranges so that I can > run a query that says, select country name where #phoneNumber# is within > the range. > > I tried inporting the values in as bigints.. no dice, by the way this info > is coming in from an excel sheet. > > > Thanks, > > Michael Tangorre > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4