We have a table 'Testing' having with one of the fields as txt_acct_oper_instrs1 char(255) null
A sample value of the data in the field is "ABCD$$$$NMKUY$$JUKL$ANH$ $$ adfd"
In our stored procedure while selecting this field, we want to replace all the instances of character '$' by '#' . The position and number of '$' in the data varies from record to record. Is there a system procedure/function which we can use to achieve the above?