I need a sql function to extract some specific words from string.
These are the requirement
1. Identify specific word(s) and copy extracted word into the column "Name".
2. In case that there are multiple words extracted. Copy the content of the row into new row and copy the second extracted word into the column "name"
Dataset attached. The first tab includes the dataset and second tab.. the expected results
Hi, I have more than 8 years experience in Database Development. I write SQL code daily and I handle refactoring and optimization on a daily basis. I will be happy to help you out with your code. Lucian