I have some SQL like the following but it is case sensitive. It’s been suggested that iLike could be used instead of Like but Base doesn’t seem to accept it. Is there an equivalent that I can use in my code? (In the example, I want the update to apply where the Description is Freds Groceries, FREDS Groceries or FREDS GROCERIES or any combination of upper and lower case).
Example:
UPDATE “tblSpend”
SET “Type” = ‘77’
WHERE (“Description” Like ‘%Freds Groceries%’)
Please, update your message with LibreOffice information: version, OS and type DB you use.
WHERE (UPPER("Description") Like UPPER('%Freds Groceries%'))Sorry, it’s a while since I posted here. Here is the system info:
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
Environment: CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045);
User Interface: UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Misc Calc: CL threaded
Database HSQLDB Embedded
Looks like Villeroy has the answer. I actually had that suggestion made elsewhere but then the idea of using iLike came up, so I thought I’d ask here.
Thanks for the replies.
