sknox (7/10/2009)
"In this case, the number of characters that are returned is the largest value of either the sum of start_expression and length_expression or 0."
quote]
Yes the MSDN documentation is incorrect but SQL engine is following the ANSI standard, thankfully, but it is confusing with incorrect documentation 🙂
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform