SyntaxFix
Write A Post
Hire A Developer
Questions
May be this one help :)
DECLARE @SearchCriteria VARCHAR(25) SET @SearchCriteria = 'employee' IF CHARINDEX('%', @SearchCriteria) = 0 BEGIN SET @SearchCriteria = '%' + @SearchCriteria + '%' END SELECT * FROM Employee WHERE Name LIKE @SearchCriteria