SELECT TOP 10 * FROM ( SELECT * FROM ( SELECT Univadis2_Articles.ArticleID, Univadis2_Articles.Title, dbo.StripHTMLTags(Univadis2_Articles.Long_Resume) As SubSection, dbo.StripHTMLTags(Univadis2_Articles.Short_Resume) As Section, Univadis2_Articles.ExternalLink FROM Univadis2_Articles INNER JOIN Univadis2_ContentServices ON Univadis2_Articles.ContentServiceNodeID = Univadis2_ContentServices.NodeID AND Univadis2_ContentServices.Title= 'MIMS' WHERE 1=1 And dbo.Univadis2_Articles.Long_Resume IS NOT NULL AND dbo.Univadis2_Articles.Short_Resume IS NOT NULL AND (Univadis2_Articles.Title LIKE '%twist%' OR Univadis2_Articles.Keywords LIKE '%twist%') ) Univadis2_Articles ) Univadis2_Articles Order By Cast(Section As Varchar(100)), Cast(SubSection As Varchar(100))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)