Replace Special Character and Keep What You Want

Question

Replace Special Character and Keep What You Want

Vingo

Grasshopper

Points: 19
More actions
March 6, 2013 at 1:21 am

#274948

Comments posted to this topic are about the item Replace Special Character and Keep What You Want

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004696 More actions · Answer 1

Thank you for your effort but your code doesn't actually work as claimed. Try the following and see why. You need to go back to Books Online and learn a bit more about PatIndex and LIKE comparisons.

SELECT DBO.fn_replace_special_char('test,1^23@[sql].com')

Also, consider the use of a Tally Table instead of a WHILE loop. If you don't know what that is or how it can be used to replace certain loops in a highperformance manner, please see the following article.

http://www.sqlservercentral.com/articles/T-SQL/62867/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)