"replace" command equivalent

[jkj2001]

We're trying to run the following command from tsql, and would like to use a thunderstone equivalent for SQL Server's "replace" command, if possible:

update mytable set box_number = replace(box_number,'RECI- 00204','RECI-00204')
where box_number = 'RECI- 00204'

Can you point us in the right direction? Thanks!

[mark]

Well, in your example there's no need since it's the whole field and simple assignment would suffice. But in the general case use "sandr". See
http://thunderstone.master.com/texis/ma ... &q=replace