Dealing with comma delimited data in a database column

This is pure goodness from Lazy Coder:

Quote:

For various reasons, developers through the years have decided to store lists of data as comma-separated lists. Most programming languages include a split() function that allows you to break apart a list of data using a specified character. T-SQL does not. READ MORE AND SEE THE CODE…