5 lines
234 B
SQL
5 lines
234 B
SQL
select dbo.ve_GetShortPathFromContentID(CC.ContentID) Location, substring(text,76,20) Part1, ContentID, Text
|
|
from contents cc
|
|
where type between 10000 and 19999
|
|
--and text Like '%WCNS%' or
|
|
and substring(text,72,5) like ' [A-Z]' |