Report cemeteries

[^maikl11 0]

I want to create a report that shows me all the cemeteries in my database.

I entered that here:
SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr, burialdate, burialplace, lastname, firstname, deathpersondate, deathplace, tng_people.ID., Deathplace, tng_people , tng_people.gedcom, nameorder FROM (tng_people) WHERE (burialplace LIKE "% Friedhof%" OR "Memorial" OR "Cemetery") AND tng_people.gedcom = "KLERC" ORDER BY burialplace

But only places that contain the word "Friedhof" are shown to me:
Cemetries and memorials are not displayed!
Where am I making the mistake?
Thank you for your help in advance....

[Michel KIRSCH 0]

41 minutes ago, ^maikl11 said:

burialplace LIKE "% Friedhof%" OR "Memorial" OR "Cemetery"

Must certainly be:

burialplace LIKE "% Friedhof%" OR burialplace LIKE "%Memorial%" OR burialplace LIKE "%Cemetery%"

Michel

[^maikl11 0]

vor 39 Minuten schrieb Michel KIRSCH:

Must certainly be:

burialplace LIKE "% Friedhof%" OR burialplace LIKE "%Memorial%" OR burialplace LIKE "%Cemetery%"

Michel

Perfect..... Thank you Michel