Invalid Length Parameter Passed To The RIGHT Function

About 2 weeks ago some SQL that has been working for the past 6 months started throwing an error without anything changing. I spent a couple days trying to find out what was going

Solution 1:

Perhaps if you can't find the cause (it's probably bugging production environment), you could rewrite using SUBSTRING? Or a combination of REVERSE & LEFT.