^maikl11 0 Report post Posted February 12 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.... Share this post Link to post Share on other sites
Michel KIRSCH 0 Report post Posted February 12 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 Share this post Link to post Share on other sites
^maikl11 0 Report post Posted February 12 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 Share this post Link to post Share on other sites