if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[udf_ReplaceChars]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[udf_ReplaceChars] GO CREATE FUNCTION dbo.udf_ReplaceChars ( @ReplaceList VARCHAR(50), @String VARCHAR(100) ) RETURNS VARCHAR(100) AS BEGIN DECLARE @Char CHAR(1), @Loop INT SET @Loop = 0 WHILE @Loop <= LEN(@ReplaceList) BEGIN SET @Loop = @Loop + 1 SET @Char = SUBSTRING(@ReplaceList, @Loop, 1) SET @String = REPLACE(@String, @Char, '') END RETURN @String END GO