I have an update command like this:

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

This works but it is case sensitive.

If "OldMemberTableName" is like "OLDMEMBERTABLENAME", it will not be replaced.

I tried inserting UPPER( syntax in there but it never replaces it properly.

How can I make such command case insensitive?