String functions, such as MID() need to know where the substring you’re extracting begins and ends. When that information is unknown or inconsistent from one value to another, you’ll have to ...