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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
