Using This Query you can remove special characters from string in sql
DECLARE @str VARCHAR(400)
DECLARE
@expres VARCHAR(50) = '%[~,@,#,$,%,&,*,(,),.,!]%'
SET @str = '(remove) ~special~
*characters. from string in sql!'
WHILE PATINDEX( @expres, @str ) > 0
SET
@str = Replace(REPLACE( @str, SUBSTRING( @str, PATINDEX( @expres, @str ), 1 ),''),'-',' ')
SELECT @str
yeahh this query solve out my problem , thanks nice article .
ReplyDelete