How do i write this like query

Hi,

This is not working for me..

Let me know what is wrong in the query below

"select a.Status,a.AssignmentID,ta.Task,p.ProjectName,m.Module,l.FName+' '+l.Lname as AssignedTo,a.StartDate,a.EndDate,a.Duration from assignment_master a left outer join ProjectDetailsMaster p on p.ProjectID=a.ProjectID left outer join module_master m on m.ModuleID=a.ModuleID left outer join login_master l on l.LoginID=a.AssignedTo left outer join task_master ta on ta.TaskID=a.Task where p.ProjectName LIKE '" + value+ "%' OR ta.Task LIKE '" + value + "%' OR AssignedTo LIKE '"+value+"%'"