SQL is designed for set based operations. It does include some ability for row based programming and string manipulation. It may not be an optimal solution. But, if it is a small task or using a different language or tool is not an option, it can be done. Today we will create a function to break out a list from a string input.
We will use a familiar form, the doctor’s patient background form. Here we have to list allergies and surgeries. Our job is to get this information in the database. We want to convert them from string lists into rows for processing.