CREATE FUNCTION dbo.trim( @val nvarchar(max) )
RETURNS nvarchar(max)
BEGIN
DECLARE @tab nchar(1)
, @lf nchar(1)
, @cr nchar(1)
, @crlf nchar(2)
SET @tab = char(9)
SET @lf = char(10)
SET @cr = char(13)
SET @crlf = char(13) + char(10)
RETURN ( replace(replace(replace(replace(ltrim(rtrim(@val)), @tab, ”), @crlf, ”), @lf, ”), @cr, ” ) )
END –trim()