SQL Query

[smartinukl]

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 characters.

Any ideas?

Any help appreciated.

S

 

[xenou]

What is the database - SQL Server, Access, Oracle, etc..

Or are you pulling the fields from a database but working with them in Excel?

 

[SydneyGeek]

Could I ask why you want this to be a number field? That's a no-no with numeric data that will not be calculated, eg phone numbers and numeric post codes.
They should be stored as text.

Denis

 

[Norie]

I've got to agree with Denis - why do you want this field to be a number?

SQL does have CAST but I think that's meant to be used to change one data-type to another.

As far as I know there is no 'telephone no' datatype.

You might want to look at REPLACE but I'm still not sure if that would do what you want.

Where are you getting the data from and why do you want it to be turned into a number?

Perhaps you should look at splitting it out into international/state/regional codes etc in separate fields?