I have phone numbers in a nvarchar(20) Column I need to remove all
Non numeric Characters and remove extra number leaving a 10 digit number
Is there to replace using like % a-z %
This is what I am using now
Non numeric Characters and remove extra number leaving a 10 digit number
Is there to replace using like % a-z %
This is what I am using now
Code:
CONVERT( varchar(10),REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(RTRIM(LTRIM(ShippingPhone))},CHAR(13),''),CHAR(9),''),CHAR(10),''),',',''),'-',''),'.',''),')',''),'(',''),' ',''),'/',''))