A stored procedure can be used to which the
Search Type
and
Search Value
are passed as arguments as shown below
CREATE PROCEDURE dbo.SearchData (@SearchType NVARCHAR(100), @SearchValue NVARCHAR(100))
AS
BEGIN
DECLARE @FilterExp NVARCHAR(250)
SET @FilterExp = CASE @SearchType
WHEN 'Name' THEN 'WHERE Name = ''' + @SearchValue + ''''
WHEN 'SerialNumber' THEN 'WHERE SerialNumber = '''+ @SearchValue + ''''
WHEN 'All' THEN ' '
END
Exec( 'SELECT * FROM tbluser ' + @FilterExp )
END
Then to call
EXEC dbo.SearchData 'Name','UserName'