This is based off of question ID: 28683827. I had a question on how to return the last value in a string after any variations of LCF in between company names. I want to add some additional logic to the function.
If the string ends with any of the variations of LCF and there is no company name after the last LCF I want to identify it somehow and I will write it to a table. Im thinking that if this happens I want something returned that I can look for(lets say the string '999' for now) and Ill write the bad value to a table.
Just so you know, the table with the bad records will be sent to the department that handles these names and they will enter the correct company and we will fix the data.