agreeing with Dave, it seems to work fine, but it assumes that MFM always exists and is always those three letters int eh first three chars.

if we are grabbing something from the middle of an existing string, we need to find the start of MFM instead of assuming the first 3 chars

I just put this sample data together as an example:, maybe it doesn't always exist? is that it?

With MySampleData([Business Unit])

AS

(

SELECT 'MFMGOOGLE' UNION ALL

SELECT 'MFMArnoldDeCaprio' UNION ALL

SELECT 'MFMBruceSchwarzenegger' UNION ALL

SELECT 'MFMArnoldDamon' UNION ALL

SELECT 'MFMLeonardoPitt' UNION ALL

SELECT 'MFMBruceWahlberg'

)

SELECT SUBSTRING([Business Unit], 4, 50) FROM MySampleData