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!
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!