You are here: Home > Technical Articles > MS SQL Server - Function Trim

MS Sql Server - Script Function Trim


SQL script for string trim.

CREATE FUNCTION [dbo].f_trim(
            @string        varchar(5000)
)
RETURNS varchar(5000)
BEGIN
    RETURN LTRIM(RTRIM(@string))
END
GO


Published On: 02 Aug 2009