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]'