hi ,
How to check phone in SQL server 2005
Example :
phone char(10) not null -- phone include : number
if len(convert(int,phone)) <> 10
print 'Phone include 10 number'
if convert(int,phone) <> [0-9]
print 'Phone not char'
It`s look like . But it`s not worked
Can you help me about this trouble ?
...
Go to the complete details ...