通配符用在参数上的问题

Question

SELECT book.BookId, book.BookTitle, book.BookAuthor, book.BookCategoryId, 
      book.BookCategoryName, book.BookDescription, book.BookView, book.BookImage, 
      book.BookDate, book.BookSellerId, book.BookInformationFolder, book.BookCount, 
      book.BookISBN, book.BookPublisher, book.BookPrice, book.BookDiscounts, 
      book.BookPages, book.IsMailPrice, book.MailPrice, book.MailWay, book.BookList, 
      book.BookLook, book.BookInLock, aspnet_Users.UserName
FROM book INNER JOIN
      aspnet_Users ON book.BookSellerId = aspnet_Users.UserId
WHERE (UPPER(BookPublisher) LIKE REPLACE(UPPER(%@BookPublisher%), ' ', '%'))怎么办%@BookPublisher%不能这么写啊

Answer 1

LIKE '%'+UPPER(@BookPublisher)+'%'

Answer 2

你要做什么？uper函数里不能含有%

Answer 3

--这样?
SELECT book.BookId, book.BookTitle, book.BookAuthor, book.BookCategoryId, 
      book.BookCategoryName, book.BookDescription, book.BookView, book.BookImage, 
      book.BookDate, book.BookSellerId, book.BookInformationFolder, book.BookCount, 
      book.BookISBN, book.BookPublisher, book.BookPrice, book.BookDiscounts, 
      book.BookPages, book.IsMailPrice, book.MailPrice, book.MailWay, book.BookList, 
      book.BookLook, book.BookInLock, aspnet_Users.UserName
FROM book INNER JOIN
      aspnet_Users ON book.BookSellerId = aspnet_Users.UserId
WHERE (UPPER(BookPublisher) LIKE REPLACE(UPPER(@BookPublisher), ' ', '%'))

Answer 4

SELECT book.BookId, book.BookTitle, book.BookAuthor, book.BookCategoryId, 
      book.BookCategoryName, book.BookDescription, book.BookView, book.BookImage, 
      book.BookDate, book.BookSellerId, book.BookInformationFolder, book.BookCount, 
      book.BookISBN, book.BookPublisher, book.BookPrice, book.BookDiscounts, 
      book.BookPages, book.IsMailPrice, book.MailPrice, book.MailWay, book.BookList, 
      book.BookLook, book.BookInLock, aspnet_Users.UserName
FROM book INNER JOIN
      aspnet_Users ON book.BookSellerId = aspnet_Users.UserId
WHERE (UPPER(BookPublisher) LIKE REPLACE(UPPER(@BookPublisher), ' ', '%'))SELECT book.BookId, book.BookTitle, book.BookAuthor, book.BookCategoryId, 
      book.BookCategoryName, book.BookDescription, book.BookView, book.BookImage, 
      book.BookDate, book.BookSellerId, book.BookInformationFolder, book.BookCount, 
      book.BookISBN, book.BookPublisher, book.BookPrice, book.BookDiscounts, 
      book.BookPages, book.IsMailPrice, book.MailPrice, book.MailWay, book.BookList, 
      book.BookLook, book.BookInLock, aspnet_Users.UserName
FROM book INNER JOIN
      aspnet_Users ON book.BookSellerId = aspnet_Users.UserId
WHERE (UPPER(BookPublisher) LIKE '%' + REPLACE(UPPER(@BookPublisher), ' ', '%') + '%')

Answer 5

LIKE  '%'+REPLACE(UPPER('@BookPublisher'), ' ', '% or like %')+'%'
?

Answer 6

select '%'+REPLACE(UPPER('ab cd'), ' ', '% or like %')+'%'/*%AB% or like %CD%*/

Answer 7

SELECT book.BookId, book.BookTitle, book.BookAuthor, book.BookCategoryId, 
      book.BookCategoryName, book.BookDescription, book.BookView, book.BookImage, 
      book.BookDate, book.BookSellerId, book.BookInformationFolder, book.BookCount, 
      book.BookISBN, book.BookPublisher, book.BookPrice, book.BookDiscounts, 
      book.BookPages, book.IsMailPrice, book.MailPrice, book.MailWay, book.BookList, 
      book.BookLook, book.BookInLock, aspnet_Users.UserName
FROM book INNER JOIN
      aspnet_Users ON book.BookSellerId = aspnet_Users.UserId
WHERE (UPPER(BookPublisher) LIKE '%' + REPLACE(UPPER(@BookPublisher), ' ', '%') + '%')

Answer 8

WHERE (UPPER(BookPublisher) LIKE REPLACE('%'+UPPER(@BookPublisher)+'%', ' ', '%'))