Hey Gurus and Grand Masters 😎
I have xml stored in a column with data type = text. I need to update multiple substrings of data within that text column (ie update ‘<data>1</data>’ to ‘<data>Test</data>’, ‘<data>2</data>’ to ‘<data>Test2</data>’). In trying the Replace function, it returns this message: Argument data type text is invalid for argument 1 of replace function.
In light of this, I am using the updatetext function instead. Due to the column data type of text, this function requires a delete_lengthvalue in bytes. Right now I have string length, I am looking for the best way to calculate byte length. Is there a built-in function to do this? Multiplying by a factor seems to work in some cases but not all, I am still in the midst of testing this…