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

514 reads

Blogs

Microsoft Tools That Help Query Tuning

By

Query tuning is not easy. In fact, for a lot of people, you shouldn’t...

Author of the Year 2019 Nomination at MSSQLTips

By

This year I’ve been nominated again for the Author of the Year award at...

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

Read the latest Blogs

Forums

Upgrading SQL Service Packs on multiple versions

By Lord Slaagh

Hello SSC, My company has SQL versions that range between 2008 R2 to SQL...

Dynamic images within my report

By Shabbaranks

Hi, Im trying to get dynamic images in my report based on a Tablix...

Setting fill factor on an auto-increment INT clustered index

By Mr. Holio

Hi all, Please consider the following table structure. CREATE TABLE [dbo].[Transactions]( [Id] [int] IDENTITY(1,1)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers