SQL Tutorials and .Net Tutorials
Showing posts with label
difference between len() and datalength() in SQL Server 2005
.
Show all posts
Showing posts with label
difference between len() and datalength() in SQL Server 2005
.
Show all posts
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.
Older Posts
Home
Subscribe to:
Posts (Atom)