Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

Transact-SQL reference for the STRING_SPLIT function. This table-valued function splits a string into substrings based on a character delimiter.

Splits the text according to each : character in the example:value:data variable. The result will be a table with 3 rows.

Search for “stored procedure” and select the option for “SQL Server – Execute stored procedure ... you can download an app for generating a formula that can split the text string from Flow back into ...