Thunderstone Support Forums

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!

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