Brother is waiting for an answer here.

reversal

update data set description
=
select left (description, charindex ('<Br>', description) -1) as description from data where num in (
 select num from data
where description like '% <Br>%')

where where description like '% <Br>%'


I mean, modify the description to the query, but I can't write it like this, why?

prajna

Because the subquery has multiple values

nankeny

Try:

update data set description
= left (description, charindex ('<Br>', description) -1)
where description like '% <Br>%'

cv4bf5d65fd

update data set description = left (description, charindex ('<Br>', description) -1)
where description like '% <Br>%'

fanfan1980

--try

update data set description = left (description, charindex ('<Br>', description) -1)
from data
where charindex ('<Br>', description)> 0

unkmass

update data set description
=
select left (description, charindex ('<Br>', description) -1) as description from data where num in (
select num from data
where description like '% <Br>%')

where where description like '% <Br>%'
-----------
Can there be two consecutive where there is no problem!

prajna

Sharp upstairs. . . No one saw it. . .

lancelover

update data set description
=
select left (description, charindex ('<Br>', description) -1) as description from data where num in (
select num from data
where description like '% <Br>%')