I need to check if area code is there than do nothing else
pad the number with the area code.
There is a new area code being introduce the 431. How should I set this up.
dbo.tblUsers Phone nvarchar(14)
INSERT INTO #tmp VALUES('(204) 325-4059');
INSERT INTO #tmp VALUES('204-940-1261');