REPLACE() in a non-case-sensitive way?

Question

Hi,

This question is probably rather basic, but I didn't actually realize until today that the behavior of the REPLACE() function is case sensitive.

What's the best way today to use a non-case-sensitive REPLACE() function?  Would REGEX_REPLACE() accomplish what I need?

MarqueeCrew · Accepted Answer

yes.  regex_replace([field],"WoRd", 'Replacement') will work because the default is case insensitive.