Dynamic SQL for search

CREATE PROCEDURE [dbo].[spUserInfo_SearchSp]
(
    @SearchItem varchar(50),<pre></pre>
    @SearchBy varchar(50)
)
AS
BEGIN
    SET NOCOUNT ON;
    
    Select 
        UserName, FirstName, LastName, EmailId, IsActive
    From UserInfo
    where 
       (@SearchBy='UserName' AND UserName like '%'+@SearchItem+'%')
    OR (@SearchBy='FirstName' AND  FirstName like '%'+@SearchItem+'%')
    OR (@SearchBy='LastName' AND LastName like '%'+@SearchItem+'%')
    OR (@SearchBy='EmailId' AND EmailId like '%'+@SearchItem+'%');
        
END