SourceCode/PROMS/SQL/ulnone.sql

5 lines
200 B
SQL

select contentid, .dbo.ve_getpathfromcontentid(contentid),
substring(text,patindex('%\ul%',text),4),
text
from contents where text like '%\ul%'
and substring(text,patindex('%\ul%',text),4) <> '\ul '