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