Le Roi Est Mort, Vive Le Roi!

Now that SQL Server 2008 is out the door, I’m full throttle on my new job. I’m totally excited about the improvement I’m working on, and I can’t wait to start blogging about it (once it’s out of secrecy.)   Today I’m only changing the outlook of my blog to reflect my new emploi. Yes,…

2

The Edm.Length() Canonical Function over SqlClient

I recently blogged about canonical functions in Entity Framework and SQL Server’s LEN() function. The purpose of those two posts was to lay out the foundation for this one, and to allow it to be brief and coherent. Please read those two posts before proceeding.   If you’ve been using the Edm.Length() canonical function from…

2

SQL Server’s LEN() Function

There is a peculiarity around the LEN() function in SQL Server that not many people have realized or paid attention to. It’s the treatment of trailing spaces. The documentation says:           “Returns the number of characters of the specified string expression, excluding trailing blanks.” (The highlighting is mine.)   Indeed           SELECT LEN(‘abc’), LEN(‘abc         ‘);…

3