Home Forums Data Warehousing Integration Services help writing SUBSTRING() expression please RE: help writing SUBSTRING() expression please

  • June 3, 2013 at 2:46 am

    #1620415

    Hi,

    For getting the substring except MFM from the SQL Server DB itself,

    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 REPLACE([Business Unit], 'MFM','') FROM MySampleData