Is there any way to replace a set of characters, case INsensitively.
For ex,
Code: Select all
My input can be
Hash_CRC_TABLE1
HASH_crc_Table2
My output should be
Hash_TST_TABLE1
HASH_TST_Table2
In the above ex, i want to replace the word "CRC" to 'TST" , without changing the other letters. Is there anyway to do it in server jobs or in server routines?