I ran into something a little odd this morning and thought I'd submit it for commentary. Can someone explain why the following SQL query prints 'equal' when run against SQL 2008. The db compatibil...

Recently I faced a issue when using len() in a query to find out the length of a query, len() was not counting the trailing spaces in the value. But datalength() is counting the trailing spaces als...

I have a table in SQL Server. This table has an image field and the application stores files in it. Is there a way to read the size of the file in the image field using T-SQL?

Does anyone know a good way to count characters in a text (nvarchar) column in Sql Server? The values there can be text, symbols and/or numbers. So far I used sum(datalength(column))/2 but this on...

Is there some efficient way how to get length of data in "varbinary(max) filestream" column? I found only samples with conversion to varchar and then calling the "LEN" function.

What is the difference between len() and datalength() in SQL Server 2005?