• Son of a gun, it did not occur to me to use a RIGHT inside the charindex. That's pretty sweet.

    Thanks, Geoff.