Friday, June 26, 2009

difference between len() and datalength() in SQL Server 2005

select len(Column3) ,datalength(Column3) from dbo.tbl1

len(Column3)
1. LEN() return the Number of Character present neglecting space.
datalength(Column3)
1. DATALENGTH() return the Number of Byte , considering space.

No comments: