Wednesday, July 17, 2013

Mimic Oracle's TRIM function in SQL Server 2012


CREATE FUNCTION dbo.TRIM(@string VARCHAR(MAX))
RETURNS VARCHAR(MAX)
BEGIN
DECLARE @rtrn varchar(MAX)
SELECT @rtrn = LTRIM(RTRIM(@string))
RETURN iif(@rtrn = '',NULL,@rtrn)
END
GO

No comments:

Post a Comment