Hi,
We have a table ci_acct_oper_instrs 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?

Regards
Lalit

issues_sybase@hotmail.com (Lalit) wrote in message news:<7bcd3933.0310302013.4ec0cd41@posting.google. com>...
> Hi,
> We have a table ci_acct_oper_instrs 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?
>
> Regards
> Lalit


Using a combination of the SQl commands stuff and replicate you should
be able to so this. You will need to look at the TSQL sybase manual
for a full explaination