Removing numeric/special character in a variable in SQL

Asked Dec 03 '18 at 21:35

Active Dec 03 '18 at 22:27

Viewed 37 times

I would like to remove all the numbers and special character within the string in t-sql. is there any way to do it? Thanks!

input

Provider_Name
LOBLAW PHARMACY 4075
THE DRUGSTORE PHCY
411 DRUGSTORE PHCY 
THE DRUGSTORE'S PHCY
LOBLAW DRUGSTORE1032

Provder_Name
LOBLAW PHARMACY
THE DRUGSTORE PHCY
DRUGSTORE PHCY 
THE DRUGSTORES PHCY
LOBLAW DRUGSTORE

edited Dec 03 '18 at 22:27

GMB

asked Dec 03 '18 at 21:35

John

2

What version of Microsoft SQL are you using? – Sparky Dec 03 '18 at 21:39
Possible duplicate of [How to strip all non-alphabetic characters from string in SQL Server?](https://stackoverflow.com/questions/1007697/how-to-strip-all-non-alphabetic-characters-from-string-in-sql-server) – StoneGiant Dec 03 '18 at 23:36
I am using microsoft sql @Sparky – John Dec 04 '18 at 14:28
What version number of Microsoft SQL (2012,2014,2016?) – Sparky Dec 04 '18 at 19:51