>UPDATE EmailTemplate SET Subject_E=CAST(REPLACE(CAST(UPPER(Subject_E) AS NVarchar(MAX)),N'[OldMemberTableName]',N'[Member]') AS NText) >