You don't need either LTRIM nor RTRIM nor SUBSTRING.
All it takes is:
SELECT @stringWithTab = REPLACE(@stringWithTab, CHAR(9), '')
.. now @stringWithTab contains 'stringWithOutTab'
PS.
Invalid msg about substring is when the parameters gets negative.
DS.
/Kenneth