LEN function removes trailing spaces of string while DATALENGTH consider trailing spaces.
Below is Example.
This is the output of above select statements.
Below is Example.
CREATE TABLE #tmp (h1 varchar(10))
GO
INSERT INTO #tmp VALUES ('abc ')
INSERT INTO #tmp VALUES ('abc')
GO
SELECT LEN(h1) as 'LEN(EqualWithSpace)',DATALENGTH(h1) as 'DATALENGTH(EqualWithSpace)', * FROM #tmp WHERE h1 = 'abc '
SELECT LEN(h1) as 'LEN(LikeWithSpace)', DATALENGTH(h1) as 'DATALENGTH(LikeWithSpace)', * FROM #tmp WHERE h1 LIKE 'abc %'
SELECT LEN(h1)as 'LEN(LikeNoSpace)', DATALENGTH(h1) as 'DATALENGTH(LikeNoSpace)', * FROM #tmp WHERE h1 LIKE 'abc%'
GO
DROP TABLE #tmp
This is the output of above select statements.

No comments:
Post a Comment