making it a flexible option for splitting strings in SQL Server. This function can be used to add data to the output table, as its return type is “table”. CREATE FUNCTION [dbo].[split_string] ( ...