I'm facing an odd problem. I have a query:
SELECT "Kürzel", "Autor(en)", "Titel" FROM "tblTitelangaben" WHERE "Titel"||"Kürzel"||"Monographie-Kürzel"||"Autor(en)" ILIKE '%er%';
this works like a charm.
but if I add another ||"something" - which might be emtpy, I get no results.. why?
WHERE "Titel"||"Kürzel"||"Monographie-Kürzel"||"Autor(en)"||"Herausgeber" ILIKE '%er%';
|| is the same as "OR", is it not?
1 OR 0 = 1 1 OR 1 = 1 0 OR 0 = 0 right? therefore I should get the same, or more results...
any hints are greatly appreciated!
TIA, alex
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
