• Need another ' at the end try

    Select '\\Chicagofs\Ameritech\Sbc\''ECM.DM.LIST.0001000037.TEST'''

    and you get

    \\Chicagofs\Ameritech\Sbc\'ECM.DM.LIST.0001000037.TEST'

    which is what T-SQL will be using internally.