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:
Post a Comment