13 December 2013

How to Get Trim String in SQL Server

SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO
CREATE
 FUNCTION [dbo].[TRIM](@string VARCHAR(MAX))RETURNS VARCHAR(MAX)BEGIN
RETURN
 LTRIM(RTRIM(@string))END

No comments:

Post a Comment