Extracting Numeric data access

Question

I am trying to extract only the numeric data from a database. If there are no numbers it should return 0. Here is some sample data i'm dealing with.

BROK.0995684066-ACT

QCR302136900

pending

SP 33757

548751

376.A-ASA

Is there an easy way to get this done?

Thanks

Are you looking for something like this? [Strip out non-numeric characters in SELECT](http://stackoverflow.com/a/12570564/77335) — HansUp, Feb 10 '15 at 21:08

score 1 · Answer 1 · edited May 23 '17 at 12:05

1

Using the answer posted here I used the posted expression to remove all of the non-numerics leaving me with only the numbers which is exactly what i wanted.

edited May 23 '17 at 12:05

Community

1
1

answered Feb 10 '15 at 23:42

Harrison

21
2

Extracting Numeric data access

1 Answers1