38 lines
1.5 KiB
SQL
38 lines
1.5 KiB
SQL
select * from vefn_getversionnames ()
|
|
|
|
--find occurences
|
|
select itemid, text from contents cc
|
|
join vefn_getversionitems ('163') vi on cc.contentid = vi.contentid
|
|
where text like '%will TRIP%'
|
|
and text like '%will TRIP%'
|
|
COLLATE Latin1_General_CS_AS
|
|
|
|
--remove bold and underline
|
|
update cc set text = replace(text, 'CONCENTRATION OPEN', 'CONCENTRATION\u160?OPEN') from contents cc
|
|
join vefn_getversionitems ('163') vi on cc.contentid = vi.contentid
|
|
where text like '%CONCENTRATION OPEN%'
|
|
COLLATE Latin1_General_CS_AS
|
|
|
|
--add bold and underline
|
|
update cc set text = replace(text, 'are NOT in', 'are \b\ul NOT\b0\ulnone in') from contents cc
|
|
join vefn_getversionitems ('162') vi on cc.contentid = vi.contentid
|
|
where text like '%are NOT in%'
|
|
COLLATE Latin1_General_CS_AS
|
|
|
|
--add bolding
|
|
update cc set text = replace(text, 'display AND SEND', 'display AND \b SEND\b0\none ') from contents cc
|
|
join vefn_getversionitems ('161') vi on cc.contentid = vi.contentid
|
|
where text like '%display AND SEND%'
|
|
COLLATE Latin1_General_CS_AS
|
|
|
|
--add underlining
|
|
update cc set text = replace(text, 'Either "Ch', 'If \ul either\ulnone CC') from contents cc
|
|
join vefn_getversionitems ('159') vi on cc.contentid = vi.contentid
|
|
where text like '%If either CC%'
|
|
COLLATE Latin1_General_CS_AS
|
|
|
|
--(change text)
|
|
update cc set text = 'ATTACHMENT 1 - INPUT MODULE FAILURE' from contents cc
|
|
join vefn_getversionitems ('161') vi on cc.contentid = vi.contentid
|
|
where text like 'ATTACHMENT 1 - INPUT MODULE FAILURE'
|
|
COLLATE Latin1_General_CS_AS |