If the hyphen were positioned consistently, MID() would work. But what do you do when the substring you want to extract could start anywhere within the string? Here’s the trick: You use the FIND ...