select count(distinct Bookid) from Bookdetails where RZONE like '%'+ @Name+'%')
Login to post response