Data type

[bbawa1]

Hi,

I have text boxes in my web form. I am typing phone number
1-769-876-2345. and try to insert this data in a column named
Cellphone which is of data type numeric(18,0). But it is giving me
error that string is not in proper format. So it is not inserting
data in datadase. What should be the datatype of this column will be.

Thanks

 

[Teemu Keiski]

Hello,

1-769-876-2345 would be considered to be a variable length of characters (it
indeed is a string), so that might indicate that proper datatype is perhaps
varchar(18), if you expect that 18 is the maximum length of string to be
inserted