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,150 reads

Blogs

Quick 6 month check – how are those learning goals going…?

By

So in January I wrote a blog post on some goals I had this...

Power BI Monthly Digest – July 2019

By

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...

Read the latest Blogs

Forums

Changing Hardware

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Changing Hardware

Always On AG

By Admingod

I was trying to create cluster for AG group and it fails to create...

Generate Random alphanumeric value based on timestamp

By Siva Ramasamy

Hi All, Thank you for looking into my question. Does anyone have a script...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Intersection

See possible answers