Ok, just found it - sorry... But this does raise a question, I have UNICODE data, but it says that LIKE only works correctly (i.e. case-insensitive) on 7-bit data. Can someone tell me please how to make it work correctly for UNICODE as well then?
As I read from the docs there, I have to override the like(x,y) function, but I don't really know how, so any help here is appreciated :-) Thanks! Dennis //-------- Software for animal shelters http://www.smartpethealth.com //-------- -----Original Message----- From: Dennis Volodomanov Sent: Friday, July 30, 2004 3:47 PM To: [EMAIL PROTECTED] Subject: [sqlite] Wildcards in LIKE Hello, Does SQLite v3 support wildcards in the LIKE statement and if yes, how do I express them? (sorry didn't find any info in the docs on this) TIA Dennis //-------- Software for animal shelters http://www.smartpethealth.com //--------

