--**************************************
--     
-- Name: fnStripChars
-- Description:Strips unwanted character
--     s from an alphanumeric value. Useful for
--      data cleanup.
-- By: Shane Lively
--
-- Inputs:@val varchar(1024) Value to be
--      stripped
@char_list varchar(255)List OF characters TO strip FROM value
--
-- Returns:Value stripped of all charact
--     ers passed in character list.
--
-- Assumes:USAGE: 
SELECT dbo.fnStripChars('123#$4%567&8dj*beys''^,a?:;','!@#$%^&*()":?><~`;,./][}{''|\')
RETURNS - '12345678djbeysa'
--
--This code is copyrighted and has-- limited warranties.Please see http://
--     www.Planet-Source-Code.com/vb/scripts/Sh
--     owCode.asp?txtCodeId=531&lngWId;=5--for details.--**************************************
--     

IF EXISTS(SELECT * FROM sysobjects WHERE name = 'fnStripChars') DROP FUNCTION fnStripChars
GO
CREATE FUNCTION [dbo].[fnStripChars] (
@val varchar(1024), --Value TO be stripped
@char_list varchar(255) --List OF characters TO strip FROM value
) 
/****************************************************************************************************
	This function strips a list OF characters FROM the value passed in.
*****************************************************************************************************/
RETURNS varchar(1024) AS 
    BEGIN 
    DECLARE @len int,
    	@char char(1)
    DECLARE @ASCII table(ASC_code int)
    SET @len = LEN(@char_list)
    WHILE (@len > 0)
        BEGIN
        	SET @char = SUBSTRING(@char_list,@len,1)
        	SET @len = @len - 1
        	INSERT INTO @ASCII SELECT ASCII(@char)
    END

    SET @len = LEN(@val)
    WHILE (@len > 0)
        BEGIN
        	SET @char = SUBSTRING(@val,@len,1)
        	SET @len = @len - 1
        	SELECT TOP 1 
        	@val = REPLACE(@val,@char,'')
        	FROM @ASCII 
        	WHERE ASCII(@char) IN(SELECT * FROM @ASCII)
    END

    RETURN @val
END