Are you not having problems with the 0's being knocked off the front of the phone numbers - I have had to store them as varchars before
HTH Simon Michael Tangorre wrote: >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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
