Try:
CREATE PROCEDURE DoMySelect
@SEARCH NVARCHAR(100)
AS
BEGIN
SET NOCOUNT ON;
SELECT *
FROM tblBusinessCategory AS b
INNER JOIN tblUser AS u ON b.BusinessID=u.BusinessCategoryId
INNER JOIN tblAddress AS a ON u.AddressId=a.AddressID
WHERE b.BusinessCategory LIKE '%' + @SEARCH + '%'
OR b.BusinessName LIKE '%' + @SEARCH + '%'
OR b.BusinessDescription LIKE '%' + @SEARCH + '%'
END
GO