Hey all !
I want to create a new data-type called 'Phone' so that I can use it when create a new Attribute, with its form is : xxx-xxx-xxxx
For example : 123-543-8978
And when users want to UPDATE my table, they must enter a string with the same form ...
I 've just see the necessary statements on http://msdn.microsoft.com/en-us/library/ms175007.aspx . I tried to do as the direction, here 's the code :
creat type PHONE as table
(
head CHAR(3),
mid1 CHAR,
mid2 CHAR(3),
tail CHAR(4)
)
go;
But it doesn 't work .
So ... Can any one please give me a solution ? Or at least a tip ?
Thank U so much ! ^^