-- String is: ..case .. else .. FieldValue + Notice + ' ' END as Foo DECLARE @SQLStatement nvarchar(4000) SET @SQLStatement = 'FieldValue + Notice + ' ' END as Foo'