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

INSERT INTO movie (movie_title, category) VALUES ('The Avengers','action, superhero,fantasy'); INSERT INTO movie (movie_title, category) VALUES ('The Ring', 'horror ...