I have a simple query that isn't working.

select * 
from table 
where '"Name (xyz)"' LIKE '