Search Columns

Hi everyone
I am trying to create a stored procedure that will searches any of the following different columns of the defferent tables

[dbo].[Store]
[dbo].[StoreType]
[dbo].[City]
[dbo].[Province]



--I joined the 4 tables below

SELECT dbo.Store.Store, dbo.Province.Province, dbo.City.City, dbo.StoreType.StoreType
FROM Store INNER JOIN
dbo.Province ON dbo.Store.ProvinceID = dbo.Province.ProvinceId INNER JOIN
dbo.City ON dbo.Store.CityID = dbo.City.CityId INNER JOIN
dbo.StoreType ON dbo.Store.StoreTypeID = dbo.StoreType.StoreTypeId Where 1 = 1

--I have 2 parameters
1.@varSearch varchar(50)
2.@varProvince varchar(50)

in @varSearch parameter You can search any thing from [dbo].[Store].Store or [dbo].[StoreType].StoreType or [dbo].[City].City
and @varProvince will be [dbo].[Province].Province

the output must show every Store,StoreType or City in the province