sknox (7/10/2009)

---

Interestingly enough, the MSDN documentation linked to from the answer incorrectly states:

"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 🙂