Alternative to the Replace function

1

Is there another similar function to “REPLACE([string] basetext, [string] text1, [string] text2)” that can be used instead?

Thanks.

2

What are you trying to achieve? Here is a list of similar functions - https://docs.dremio.com/sql-reference/sql-functions/string.html

3

This request is related to this issue:

I was able to handle it using CAST.

Thank you very much for the help.