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

512 reads

Blogs

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

Limiting the Data Frame

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Limiting the Data Frame

Micro Credentials

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Micro Credentials

CheckDB on VLDB, Geography data type

By el_Guapo

I've narrowed down a DBCC CheckDB issue to a set of tables with Geography...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers