Query to remove non-numeric charcters

[JustATheory]

Greetings,

I need to remove all non-numeric characters from a field using an SQL query, the remaining characters will be numeric.

I'm creating a new table with this process and was wondering if there is quick way to do this, possible a funcction. I did something like this using VBA years ago.

Any help is greatly appreciated.

JustATheory

 

[markros]

It may be better to use CLR function for this as T-SQL is not good with string manipulations.

If you want to do this with T-SQL code, check this link

Handy string functions and look at the chrtran function there.

PluralSight Learning Library