I am running a query to find the rows containing the character “&”
and using dbgrid to show the result.

I have tried to write query as it works in MSSQL or MYSQL

FDQuery1.SQL.Text := ‘SELECT * FROM DATA WHERE NAME LIKE ”%&%”’;
FDQuery1.Open();

instead of getting the result containing the character “&” in NAME column
it’s selecting all the rows where NAME column is not blank

other query’s working when i am finding “” in place of “&”
as FDQuery1.SQL.Text := ‘SELECT * FROM DATA WHERE NAME LIKE ”%%”’;
this query selecting the rows containing the “*” character

It’s only selecting all not null rows when i am using ”%&%” this condition.