Sacar caracteres de una String
Truco de SQL Server - Sacar caracteres de una String
------ Copy code from here --------
IF EXISTS (SELECT 1 FROM sysobjects WHERE name='ASCIICharOnly')
DROP FUNCTION dbo.ASCIICharOnly
GO
CREATE FUNCTION dbo.ASCIICharOnly (@CharData VARCHAR(50))
RETURNS VARCHAR(50)
AS
BEGIN
DECLARE @Index INT,
@ASCIIData VARCHAR(50),
@ASCIIChar INT
-- Initialization code
SET @Index = 1
SET @ASCIIData = ''
WHILE @Index < LEN(@CharData)+1
BEGIN
SET @ASCIIChar = ASCII(SUBSTRING(@CharData, @Index, 1))
--Restrict the result to A-Z and a-z
IF @ASCIIChar BETWEEN 65 and 90 or @ASCIIChar BETWEEN 97 and 122
BEGIN
-- Construct the output characters
SET @ASCIIData = @ASCIIData + CHAR(@ASCIIChar)
END
SET @Index = @Index + 1
END
RETURN @ASCIIData
END
GO
-- Sample test
SELECT dbo.ASCIICharOnly ('Vinod1234Kumar!@$%Test') AS CharValue------ Stop copy of code -----------
Más trucos de Trucos de SQL Server 2000
Trucos más leídos
Los trucos Trucos de SQL Server 2000 más vistos