-- ================================================
-- Template generated from Template Explorer using:
-- Create Scalar Function (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- This block of comments will not be included in
-- the definition of the function.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date, ,>
-- Description:	<Description, ,>
-- =============================================
CREATE OR ALTER FUNCTION fn_remover (@valor varchar(100))  
RETURNS varchar(100)  
AS  
BEGIN  

	RETURN REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@valor
	,'A','')
	,'B','')
	,'C','')
	,'D','')
	,'E','')
	,'F','')
	,'G','')
	,'H','')
	,'I','')
	,'J','')
	,'K','')
	,'L','')
	,'M','')
	,'N','')
	,'O','')
	,'P','')
	,'Q','')
	,'R','')
	,'S','')
	,'T','')
	,'U','')
	,'V','')
	,'X','')
	,'Y','')
	,'Z','')
	,'/','')
	,'-','')
	,'\','')
	,'(','')
	,')','')
	,'.','')
	,',','')
	,'|','')
	,':','')
	,'_','')
	,'*','');

END
GO

