^maikl11 Posted February 12, 2021 Report Share Posted February 12, 2021 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.... Quote Link to comment Share on other sites More sharing options...
Michel KIRSCH Posted February 12, 2021 Report Share Posted February 12, 2021 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 Quote Link to comment Share on other sites More sharing options...
^maikl11 Posted February 12, 2021 Author Report Share Posted February 12, 2021 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.