Hi all,
Need help as I am lost. I have a field in a sql table that is supposed to be a phone number field (currently nvarchar) but it has "*" and "%" in it from the dialling process.
I need to make this field a number field using the "cast" but it will not convert due to the non number...