Non Alphabetic Characters

[sleezy]

Is there a better way of removing the non alphabetic Characters In a name
And spaces sometimes double or plus. I'm doing it the long way.

Select
Ltrim(Rtrim(Replace
(Replace
(Replace
(Replace
(Replace
(Replace
(Replace
(Replace
(Replace
(Replace(Replace(Replace(Replace(Replace(Replace(R eplace(Convert(Varchar(30),a.LastName),
'( ',''),')',''),' ',''),'.',''),'[',''),']',''),'/',''),
'(',''),';',''),',',''),'-',''),'*',''),',',''),'~',''),'''''''',''),'`','') )) As LastName
from test


2. Are They any articles on batch processing with commits that have been written

[MAK]

I suggest, you to create a user defined function to do this instead of using replace function multiple times. It is not efficient.