Smooshing String Function

Smooshing - The act of removing all non-alphanumeric characters from a string. We have found several areas of our application where we need to perform cleaning on strings. The following is a SQL function which can be used to remove any non-alphanumeric characters. To use the function create the script and then SELECT dbo.fn_SmooshIt('B?\RU.,C>}E') will […]

2002-07-26

517 reads

Blogs

New Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress

By

My new course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available on Pluralsight here!...

Step By Step Installation of SQL Server 2019 with all features

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Step By Step Installation of SQL Server 2019 with all features

By

[MSSQLFUN & Decote ITeS becomes a family of 1500 individuals across the globe. Please...

Read the latest Blogs

Forums

https //ketomegamar com/vaso-prime-rx/

By lrisyjamtions

Vaso Prime RX Now for your method. Process specific exercises that you perform on...

Avamar Backup--Is it good?

By VastSQL

Dear Experts, is it good to use Avamar backup for SQL Server, currently we...

Read-only

By curious_sqldba

  I read MSFT documentation few times but couldn't find a clear answer. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers