>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?
You can use COLLATE in REPLACE function.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.