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