Did anyone try this on SQL Server 2014? I compared the BOL quote in the explanation and the one for 2008R2 and it is different.
SQL Server 2014, SQL Server 2016 Preview:
If the start position or the length is negative, or if the starting position is larger than length of the first string, a null string is returned. If the start position is 0, a null value is returned. If the length to delete is longer than the first string, it is deleted to the first character in the first string.
SQL Server 2008 R2:
If the start position or the length is negative, or if the starting position is larger than length of the first string, a null string is returned. If the length to delete is longer than the first string, it is deleted to the first character in the first string.
EDIT: never mind. The difference doesn't apply to the example.