(转) SQL替换多个特殊字符

CREATE TABLE ErrorMessage ( NA VARCHAR(20))
INSERT INTO ErrorMessage VALUES('')
INSERT INTO ErrorMessage VALUES('★')
INSERT INTO ErrorMessage VALUES('△')
GO     
      
      
CREATE TABLE  Erro  ( NA1 VARCHAR(20))
INSERT INTO Erro VALUES('实打实的大★厦')
INSERT INTO Erro VALUES('实打大★厦')
GO

       
DECLARE @REPLACECMD VARCHAR(2000)='NA1'
SELECT  @REPLACECMD ='REPLACE('+ @REPLACECMD+','''+NA+''' ,'''')' FROM  ErrorMessage
print @REPLACECMD
DECLARE @SQLCMD VARCHAR(4000)=''
SET @SQLCMD = 'select '+@REPLACECMD+'AS NECOL FROM Erro'
EXEC (@SQLCMD)
   
--NECOL
实打实的大厦
实打大厦    

 

FROM:http://topic.csdn.net/u/20100928/13/0b89a46c-4927-4986-8f27-99b4d8d8ecea.html