>I have a sp to remove special characters from an input string, and it works fine, but I am wondering if there is a slicker (is that a word?) way to do this. The code is:
>
>

>ALTER PROCEDURE [dbo].[sRemoveSCW]
>@StringIn VARCHAR(2000),
>@StringOut VARCHAR(2000) OUTPUT
>AS
>BEGIN
>	SET NOCOUNT ON;
>
>	SET @StringOut = REPLACE(@StringIn, '~', '')
>	SET @StringOut = REPLACE(@StringOut, '`', '')
>	SET @StringOut = REPLACE(@StringOut, '!', '')
>	SET @StringOut = REPLACE(@StringOut, '@', '')
>	SET @StringOut = REPLACE(@StringOut, '#', '')
>	SET @StringOut = REPLACE(@StringOut, '$', '')
>	SET @StringOut = REPLACE(@StringOut, '%', '')
>	SET @StringOut = REPLACE(@StringOut, '^', '')
>	SET @StringOut = REPLACE(@StringOut, '&', '')
>	SET @StringOut = REPLACE(@StringOut, '*', '')
>	SET @StringOut = REPLACE(@StringOut, '(', '')
>	SET @StringOut = REPLACE(@StringOut, ')', '')
>	SET @StringOut = REPLACE(@StringOut, '+', '')
>	SET @StringOut = REPLACE(@StringOut, '=', '')
>	SET @StringOut = REPLACE(@StringOut, '{', '')
>	SET @StringOut = REPLACE(@StringOut, '}', '')
>	SET @StringOut = REPLACE(@StringOut, '[', '')
>	SET @StringOut = REPLACE(@StringOut, ']', '')
>	SET @StringOut = REPLACE(@StringOut, '|', '')
>	SET @StringOut = REPLACE(@StringOut, ';', '')
>	SET @StringOut = REPLACE(@StringOut, ':', '')
>	SET @StringOut = REPLACE(@StringOut, '<', '')
>	SET @StringOut = REPLACE(@StringOut, '>', '')
>	SET @StringOut = REPLACE(@StringOut, '?', '')
>	SET @StringOut = REPLACE(@StringOut, ',', '')
>	SET @StringOut = REPLACE(@StringOut, ' ', '')
>	SET @StringOut = REPLACE(@StringOut, '/', '')
>	SET @StringOut = REPLACE(@StringOut, '\', '')
>	SELECT @StringOut
>END
>

>
>Any input or comments are appreciated!


Just don't allow to users to write such chars.
As Naomi said there is no CHRTRAN() function in SQL Server.
You could try Igor Nikiforov's User-Defined string functions Transact-SQL Download #27115