>create procedure invpage >@SearchString VarChar(50), >@PageSize Integer, >@PageNo Integer >as >set @pagesize = 10 >set @SearchString = 'Beer' > >SELECT top @PageSize inv.uid, inv.isbn13, inv.sku1, inv.description, inv.listprice, inv.webprice, inv.datepub, inv.edition, inv.pages, inv.oop, inv.binding, inv.idsect, > Annotation.annotation, author.fullname, COVERART.JFILENAME, COVERART.TFILENAME, inv.uidclient >FROM inv LEFT OUTER JOIN > Annotation ON inv.isbn13 = Annotation.isbn13 LEFT OUTER JOIN > author ON inv.uidAuthor = author.uid LEFT OUTER JOIN > COVERART ON inv.isbn13 = COVERART.ISBN13 >WHERE (inv.uidclient = 2) AND CONTAINS(inv.description, @SearchString) >>