here is similar type store proc which i have used in my app. just use urs fields:
CREATE PROCEDURE [dbo].[USP_ExtendedSearch]
(
@userName NVARCHAR(30),
@searchUsers NVARCHAR(30),
@Name NVARCHAR(30),
@City NVARCHAR(30),
@email NVARCHAR(30)
)
AS
BEGIN
SELECT a.userID,a.username AS UName,
a.firstname+' '+a.lastname AS Name,
a.useremail AS EmailID,
a.city AS City,
b.imagePath
FROM userRegistrationTB a
JOIN imageTB b
ON
a.userID=b.UserID
WHERE
a.username!=@userName
AND
a.username LIKE '%'+ISNULL(@searchUsers,'')+'%'
AND a.firstname LIKE '%'+ISNULL(@Name,'')+'%'
AND a.city LIKE '%'+ISNULL(@City,'')+'%'
AND a.useremail LIKE '%'+ISNULL(@email,'')+'%'
SET NOCOUNT ON;
END
Abhi24h, if this helps please login to Mark As Answer. | Alert Moderator