"replace" command equivalent

Post Reply
jkj2001
Posts: 142
Joined: Fri Mar 29, 2002 1:39 pm

"replace" command equivalent

Post by 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!
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

"replace" command equivalent

Post by mark »

Post Reply