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

519 reads

Blogs

What goes around comes around : T-SQL Tuesday #129

By

I almost died. I’m sure a lot of you already know this but just...

My T-SQL Tuesday #129 Time Capsule

By

This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...

Azure Database Administrator

By

Recently I found out that I passed the BETA exam for Azure Database Administrator...

Read the latest Blogs

Forums

Send me an email if this job run longer than 30 minutes

By krypto69

Hi I have a job that I need to be notified/emailed if it runs...

Time out expired on the application side

By zouzou

Hi   I have an application that is timing out i run the query...

Sum function in CTE is not calculating the right balance

By Ysa

I have table with all charges and payment the charges are 'c'  and payments...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The D in ACID

See possible answers