So I was handed a VERY complex script simply to turn into a pipe delimited file. The problem is that I cant seem to trim anything that used substring. for example I have tried all of these with no ...

We currently translate string.Trim only when no characters are specified (whitespace only), and implement it with LTRIM/RTRIM. SQL Server 2017 introduced a more fully-featured TRIM function which can ...