Filter with LIKE operator and optional clause not working

Hi there! I'm trying to use like operator with optional clause in my query by referring to this link. I'm getting the error - "Incorrect syntax near '('." How do I solve this ?

-- query 
DECLARE @Name varchar(50)
SELECT @Name = [[(SELECT TOP 1 Name FROM Employees WHERE Name LIKE "%"{{Name}}"%") -- ]] NULL

EXEC Demo_GetEmployees @Name = @name
-- SSMS profiler
DECLARE @Name varchar(50)
SELECT @Name = (SELECT TOP 1 Name FROM Employees WHERE Name LIKE "%"("dbo"."Employees"."Name" like @P0)"%") --  NULL

EXEC Demo_GetEmployees @Name = @name',N'@P0 nvarchar(4000)',N'%An%'

Hi @sgayathri
You don't control Field Filters, like I described in SQL Server stored procedure with parameters.
So change WHERE Name LIKE "%"{{Name}}"%" to WHERE {{Name}}

Thanks for the response! So, you mean to say that having LIKE operator is not possible with field filters?

@sgayathri When you use Field Filters, then you have absolutely no control over the SQL, but you can just select "String contains" in the sidebar, which will do exactly what you're trying.
Otherwise just use a Text variable instead.