wooi83

wooi83

  • NA
  • 18
  • 0

unable to use % in stored procedures - pls help...

Apr 2 2004 3:00 PM
CREATE PROCEDURE SP_listByAuthor ( @bookAuthor varchar(20) ) AS SELECT dbo.BOOKS.bookID,dbo.BOOKS.bookTitle,dbo.BOOKS.bookAuthor,dbo.BOOKS.bookISBN,dbo.BOOKS.bookPublisher,dbo.BOOKS.bookYearPublished,dbo.BOOKS.bookDateReceived,dbo.BOOKS.bookCategory,dbo.BOOKS.bookLoanStatus FROM dbo.BOOKS where dbo.BOOKS.bookAuthor LIKE %@bookAuthor% <-- errors occur from this keywords can anyone tell me how to use % in stored procedures ? i tried '%@bookAuthor%' %@bookAuthor% but errors still occur when i check the syntax. but when i try the same query in query analyser, it able to retrieve data without errors. pls help...

Answers (1)