Strip Non-numeric characters from string function

Sometimes it's necessary to strip non-numeric characters from the string, so you can convert to integer without error. Often it happens when you want to use stored procedure, especially system procedures. The output there can be already with some characters (MB, KB and such), but you want this result to be used for your own […]

5 (1)

2003-11-10

1,168 reads

Blogs

Data Saturday #8–Southwest US

By

I am very excited to announce that I will be speaking for Data Saturday...

Data Weekender v3.1

By

I am super excited about this new version of Data Weekender, coming up on...

Thanks Kathi and Mala

By

I have to thank Kathi and Mala for putting on the WIT Mental Health...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Search all Tables in DB for a String but using Postgres - What is the difference

By Oscar_Boots

Hi Forum, I want to search a Database for a String value and I...

SQL 2016 - Need help with complex calculations based on paycodes - New Changes

By DiabloSlayer

Hello Friends, Posting this for help as the client made more requirement changes. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers