This is a stumper. It's a long shot, but is there any chance that there may be unprintable characters preceding the string?

To be sure, you could try something like:

SUBSTRING(TRIM([Business Unit]), 1, 3) == "MFM" ? SUBSTRING(TRIM([Business Unit]), 4, 50): [Business Unit]