21 lines
2.0 KiB
SQL
21 lines
2.0 KiB
SQL
use veproms
|
|
select dbo.ve_GetShortPath(II.ItemID) Path,Text, Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Text,'\ul OR\ulnone ','OR'),'\ul NOT\ulnone ','NOT'),'\ul THEN\ulnone ','THEN'),'\ul IF\ulnone ','IF'),'\ul AND\ulnone ','AND'),'\ul NOT\ul0 ','NOT'),'\ul THEN\ul0 ','THEN'),'\ul AND\ul0 ','AND'),'\ul WHEN\ul0 ','WHEN'),'\ul OR\ul0 ','OR'),'\ul IF\ul0 ','IF')
|
|
from items ii
|
|
join contents cc on ii.ContentID = cc.ContentID
|
|
--where ItemID = 101
|
|
where text like '%\ul%'
|
|
use master
|
|
|
|
use veproms
|
|
Update Contents
|
|
Set Text = Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Text,'\ul OR\ulnone ','OR'),'\ul NOT\ulnone ','NOT'),'\ul THEN\ulnone ','THEN'),'\ul IF\ulnone ','IF'),'\ul AND\ulnone ','AND'),'\ul NOT\ul0 ','NOT'),'\ul THEN\ul0 ','THEN'),'\ul AND\ul0 ','AND'),'\ul WHEN\ul0 ','WHEN'),'\ul OR\ul0 ','OR'),'\ul IF\ul0 ','IF')
|
|
where text like '%\ul%'
|
|
Update Contents Set Text = Replace(Text,'GO TO','go to') where Text like '%GO TO%' Collate SQL_Latin1_General_CP1_CS_AS
|
|
Update Contents Set Text = Replace(Text,'RETURN TO','return to') where Text like '%RETURN TO%' Collate SQL_Latin1_General_CP1_CS_AS
|
|
Update Contents Set Text = Replace(Text,'REFER TO','refer to') where Text like '%REFER TO%' Collate SQL_Latin1_General_CP1_CS_AS
|
|
Update Contents Set Text = Replace(Text,'SHALL','shall') where Text like '%SHALL%' Collate SQL_Latin1_General_CP1_CS_AS
|
|
Update Contents Set Text = Replace(Text,'GREATER THAN OR EQUAL TO','greater than or equal to') where Text like '%GREATER THAN OR EQUAL TO%' Collate SQL_Latin1_General_CP1_CS_AS
|
|
Update Contents Set Text = Replace(Text,'LESS THAN OR EQUAL TO','less than or equal to') where Text like '%LESS THAN OR EQUAL TO%' Collate SQL_Latin1_General_CP1_CS_AS
|
|
Update Contents Set Text = Replace(Text,'GREATER THAN','greater than') where Text like '%GREATER THAN%' Collate SQL_Latin1_General_CP1_CS_AS
|
|
Update Contents Set Text = Replace(Text,'LESS THAN','less than') where Text like '%LESS THAN%' Collate SQL_Latin1_General_CP1_CS_AS
|
|
use master |