Use of replace

wcckuand

There is a field c1 in Table T. The value of c1 is:
<Aes> <Cmd> MAReport </ Cmd> <Preview> false </ Preview </ Aes>

<Cmd> </ Cmd> The value in the middle is not fixed and can be any character. Now I want to put all records
<Cmd> </ Cmd> This paragraph is changed to a <Cmd> self-defined </ Cmd> of a fixed character. How do I solve it if I use replace? Thank you.

恶魔右指

Use stuff, not replace

unkmass

Intercept with substring ().

unkmass

left (c1, charindex ('<Cmd>')-1) + 'self-defined' + right (c1, len (c1) -charindex ('</ Cmd>') + 1)

72251845

replace ('<Aes> <Cmd> MAReport </ Cmd> <Preview> false </ Preview </ Aes>', 'MAReport', 'example')

kittast

declare @c varchar (8000)
set @c = '<Aes> <Cmd> MAReport </ Cmd> <Preview> false </ Preview </ Aes>'

select @ c = left (@ c, charindex ('<cmd>', @ c) +4) + 'String to be replaced' + right (@ c, len (@c) -charindex ('</ cmd> ', @ c) +1)
print @c

fanfan1980

create table T (c1 varchar (100))
insert T select '<Aes> <Cmd> MAReport </ Cmd> <Preview> false </ Preview </ Aes>'

update T set
c1 = stuff (c1, charindex ('<Cmd>', c1), charindex ('</ Cmd>', c1) -charindex ('<Cmd>', c1) +6, '<Cmd> define it yourself </ Cmd> ')

select * from T
--result
c1
-------------------------------------------------- --------------------------------------------------
<Aes> <Cmd> Define yourself </ Cmd> <Preview> false </ Preview </ Aes>

(1 row (s) affected)

sinexe

declare @a varchar (8000)
set @a = '<Aes> <Cmd> MAReport </ Cmd> <Preview> false </ Preview </ Aes>'
select left (@ a, charindex ('<Cmd>', @ a) + 4) + 'I' + right (@ a, len (@a) -charindex ('</ Cmd>', @ a) + 1 )

kittast

update t1 set c = left (c, charindex ('<cmd>', c) +4) + 'String to be replaced' + right (c, len (c) -charindex ('</ cmd>', c ) +1)

116657396

If each row of records contains only one <Cmd> ... </ Cmd>:

declare @ str1 varchar (100), @ str2 varchar (20)
set @ str1 = '<Aes> <Cmd> MAReport </ Cmd> <Preview> false </ Preview> </ Aes>'
set @ str2 = 'testString'

select stuff (@ str1, charindex ('<Cmd>', @ str1) + 5, charindex ('</ Cmd>', @ str1) -charindex ('<Cmd>', @ str1) -5, @ str2)