• This article should be handy:

    DelimitedSplit8K[/url]

    Create the DelimitedSplit8K function as detailed in the article, and CROSS APPLY it to your comma-delimited data, like so:

    SELECT * FROM YourTable

    CROSS APPLY YourDatabase.YourSchema.DelimitedSplit8K(YourTable.Lastname,',')

    Replace the "Your" bits with your actual tables. This will show you how the original string, and how it will be split out based on the delimiter (in this case, the comma at the end of the DelimitedSplit8K call). From there, you'll need to update each part of the name with the split-out entries you end up with from using DelimitedSplit8K. This can be clarified further as needed, but it should provide a good starting point.

    - 😀