How to split comma separated values in SQL query?

Question

Can anyone explain how to split comma separated values in the SQL query?

Answer 1

We can use STRING_SPLIT() function to split the values on a specific separator. Here is an example to split comma separated values in SQL.

Select color from STRING_SPLIT( ‘red, blue, yellow’, ‘,’);

I advise registering for this SQL training online program by Intellipaat to learn SQL.