x CHAR:= 'Y'; --VARIABLE

SELECT a.id, a.name, a.description
FROM Table1 a
WHERE (IF x = 'Y' THEN
    a.name = parameter /*FILTER BY NAME*/
    ELSE
    /*BRING ALL (NO NAME FILTER*/);