Trim Function

,

I realize that RTrim(LTrim is not that hard to type, but, I feel this is cleaner

/*
*******************************************************************************
Created by:		Scott Williams
When created:	05/16/07
Purpose:		Trim Function
*******************************************************************************

************************************************************************************************************
MODIFICATIONS
Date		Initials	Change Made
************************************************************************************************************

Example:	

SELECT dbo.Trim(' Trim Me ')

@ThisString = The string to trim

*/

CREATE FUNCTION [dbo].[TRIM]  

(@ThisString varchar(4000))

RETURNS nvarchar(4000)

AS

	BEGIN
		DECLARE @ReturnString VARCHAR(8000)

		SET @ReturnString = RTrim(LTrim(@ThisString))

		RETURN @ReturnString
	END

Rate

1 (1)

Share

Share

Rate

1 (1)