String Function

[debashis]

How to implement replace first, replace last like string function ?

[balaji.ramaswamy]

Currently we have only this

select replace(‘Rock’,‘R’,‘L’) will give “Lock”

https://docs.dremio.com/sql-reference/sql-functions/string.html