Click here to Skip to main content
15,042,397 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:
SQL
select REPLACE('pouria',('%[a-z]'),'x')
– this code doesn’t work
Posted
Updated 19-Feb-16 1:44am
v2

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

Reference - PATINDEX (Transact-SQL)[^]
   
Comments
Pouria Polouk 21-Feb-16 8:07am
   
thank you
See HERE[^]
   
Comments
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