CLR functions that perform string manipulation and substring extraction perform very well in SQL Server. By Joe Kunk; 10/11/2011; Recently I encountered a problem in a stored procedure that was caused ...

By changing the string into XML, each part between the delimiters becomes a separate XML element. This method gives better control over complex delimiters, supports multi-character delimiters, and ...

If the ordinal output column isn't enabled, STRING_SPLIT returns a single-column table whose rows are the substrings. The name of the column is value.It returns nvarchar if any of the input arguments ...

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.