SPLIT_TABLE is a special built in table value function. It takes 3 parameters. The first parameter is a SELECT
statement. The second parameter is a column in the SELECT statement and the third parameter, is a
character to parse for. The function is designed to take the column specified by the second parameter and generate a new table splitting the data one per row by the third parameter. This function is designed to help parse information within a column into separate rows.
Example - Produces a result set with 3 rows. A in row 1, B in Row 2, C in row 3:
select * from split_table ( (select 'a,b,c' as col1 ) , col1 , ',' ) as xyz
Please sign in to leave a comment.