Searching for three or more words in SQL

See more:

SQL

where description like "'%"+prog+"%'"..... it gives me an error that says "invelid column name '%". " pls help. how to Searching for three or more words in SQL eg:- "Project management workbook" even if you start by entering "management" it must able to return the results

My Storedproc

ALTER PROCEDURE [dbo].[sp_Search]  
	@Search varchar(255) 
AS
BEGIN
	
	SET NOCOUNT ON; 
	declare @strpart1 varchar(255) select @strpart1 = SUBSTRING( @Search,CHARINDEX(' ', @Search,1),(LEN(@Search) - CHARINDEX(' ', @Search,1) + 1))
	
    -- Insert statements for procedure here
    Select Description from ['Portal Catalogue$'] 
    where Description Like '%'+@strpart1+'%' 
END