T-SQL isn't particularly well suited to advanced string manipulation. I have found that small CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.

Function inlining in SQL Server 2019 Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined. This means they will be folded into the query and no longer incur the UDF ...

Why cant I trim my substring (Oracle SQL) IO_303 Jan 28, 2011 Jump to latest Follow Reply ...