select * from (select Row_Number() over ( ORDER BY prodName ) as RowIndex, * FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND [prodName]<>N'' AND (sku like N'%svoora%' OR prodName like N'%svoora%') ) as Sub Where Sub.RowIndex >= 1 and Sub.RowIndex <= 12;

---

/

---

DECLARE @klist NVARCHAR(MAX) SELECT @klist = COALESCE(@klist+'|' ,'') + CAST(katigoriaID as varchar(20)) + '~' + katigoriaName FROM (SELECT TOP 1000 prods.prodKatID,katigories.katigoriaName,katigories.katigoriaID FROM prods INNER JOIN Katigories ON (CHARINDEX('~'+ CAST(katigories.katigoriaID as varchar(20)) +'~',prods.prodKatID) > 0 WHERE (katigories.hidden=0) AND (sku like N'%svoora%' OR prodName like N'%svoora%') ORDER BY katigories.katigoriaName) t SELECT IsNull(@klist, '')

---

SELECT DISTINCT [prodKatID] FROM [prods] WHERE (sku like N'%svoora%' OR prodName like N'%svoora%')