Click here to Skip to main content
15,663,225 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi all.
Is there a way in SQL Server 2014 that all alphabet characters of a string be converted to a special character using “replace function” and “regular expression”?

What I have tried:

Something like this:
select REPLACE('pouria',('%[a-z]'),'x')
– this code doesn’t work
Updated 19-Feb-16 1:44am

Or here on CodeProject - replace special characters in sql[^]

Reference - PATINDEX (Transact-SQL)[^]
Share this answer
Pouria Polouk 21-Feb-16 8:07am    
thank you
See HERE[^]
Share this answer
Pouria Polouk 21-Feb-16 8:08am    
thank you

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900