How to TRIM a string in MSSQL

To TRIM a string in MSSQL you can use the following Userdefinedfunction Snippet.

Sample MSSQL

CREATE FUNCTION dbo.TRIM(@inputString VARCHAR(MAX))
RETURNS VARCHAR(MAX)
BEGIN
RETURN LTRIM(RTRIM(@inputString))
END

May 22, 2015 Administrator

Apr 21, 2015 Administrator

Apr 15, 2015 Administrator

Realliferulor says:

January 21, 2015 at 9:32 am

RT @CodeSnippetsNET: TRIM UDF for MSSQL http://t.co/X0UQ25Xhb1 #mssql #sql #code #coding #dev #developer #programming

Log in to Reply