|
IF EXISTS (SELECT * FROM sysobjects WHERE name = N'f_StrTrim')
DROP FUNCTION f_StrTrim
GO
/*
Purpose : Trimming
*/
CREATE FUNCTION dbo.f_StrTrim (@str varchar(1000))
RETURNS varchar(1000)
AS
BEGIN
return ltrim(rtrim(isnull(@str ,'')))
END
Go
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.