Louis Davidson is lost in translation:
The data I am working with sometimes has people with multiple parts to their name (Mary Jo, Cindy Lou) etc, or sometimes Fred/Joe, Mary and Jack, Mary & Jack, or what have you. My goal was to turn these names into little delimited lists that I could parse on a space character with
STRING_SPLITand there were a “few” of these cases. This was the code I had arrived at when I reached the “good enough” stage of my coding.
Louis had 19 nested REPLACE() calls, but Certified Good Guy Erik Darling shows him the way.