Free Software, Source Code, and Best-Practice Documentation Index from your
Cleveland Software, Database, Web Design, Consulting, and SQL / Delphi Experts

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[udfTrim]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[udfTrim]
GO

-- ******************************************************************************************************************************/
-- Perform a FULL Trim on a string, removing both leading and trailing whitespace.
-- Microsoft SQL Server only provides left & right (LTRIM , RTRIM) functions natively.
-- This helper function makes up for what Oracle and others provide as a built-in "Trim" function.
-- Example:
--	PRINT dbo.udfTrim(' String with leading / trailing whitespace     ')
--                returns 'String with leading / trailing whitespace'
-- *****************************************************************************************************************************/
CREATE FUNCTION udfTrim
	(@vStringToTrim VARCHAR(500))
	RETURNS VARCHAR(500)
AS
BEGIN
	RETURN LTRIM(RTRIM(@vStringToTrim))
END