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
00
range end
99
That was one generic example. Basically the number represents a phone number range and
can you store them as varchar and convert them on the fly?
-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:25 AM
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
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:
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
00
range end
99
That was one generic example. Basically the number represents a phone number
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
[sorry if you get this twice, but it doesn't show up here]
Michael Tangorre wrote:
The numbers are of the following size:
range start
00
range end
99
That was one generic example. Basically the number represents a phone number
Michael Tangorre wrote:
The numbers are of the following size:
range start
00
range end
99
That was one generic example. Basically the number represents a phone number range
and I have a range for each country in the world
: Michael Tangorre [mailto:[EMAIL PROTECTED]
Sent: 13 June 2003 15:57
To: CF-Talk
Subject: Re: numbers too big
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
AM
Subject: RE: numbers too big
No specific proof, but thinking about it logially
International dialing allow 4 for Expansion (there aer some 3 digit
codes),
For Regional Exchanges allow 4 digits ( Regions), Local Exchanges
allow
4 digits, that leaves you five digits spare for individual
.
Mike
- Original Message -
From: Michael Tangorre [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 11:23 AM
Subject: Re: numbers too big
I just found this site:
http://www.1areacodescountrycodes.com/all-country-code-numbers-countrycodes.htm
which shows
10 matches
Mail list logo