Handling Columns With Multiple Values

I am writing a stored procedure that needs a access individual entries in a column with multiple entries delimited by a comma(yeah i know, not 1st NF) . Like this:








Key


NotANormalizedCol



1


1324, 5124, 5435,5467



2


423, 23, 5345



3


52334, 53443, 1224



4


12, 4, 1243,66

is there a function that returns a substring given a delimiter character? the only substring returning function that i found are the LEFT and RIGHT that returns fixed length substring.

I am pretty new to this, so I apologize if this is a trivial questions