• Since constants worked, I gave up the other approach and used a Select statement to generate a bunch of update statements:

    select 'update vend set fedid=encryptbykey(Key_GUID(''NewKey''), '''+ rtrim(fedid) + ''') where vendid='''+ vendid +''''

    from tempdb.dbo.vend2

    where rtrim(fedid) <> ''