data types

[eja2000]

i have a field in my db which will only hold phone numbers and i want it to be the pk...

the fone numbers are all digits and start with 0932
and is 11 digits long..
what datatype can i use for this?
thxs

 

[collierd]

If it has to be a numeric integer you would have to use bigint
This allows data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807)
If you can get away with chars varchar(11)

Damian.

 

[eja2000]

thx