https://bugs.documentfoundation.org/show_bug.cgi?id=143656
m.a.riosv <miguelange...@libreoffice.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |miguelangelrv@libreoffice.o | |rg Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from m.a.riosv <miguelange...@libreoffice.org> --- See the help https://help.libreoffice.org/latest/en-US/text/sdatabase/02010100.html?&DbPAR=BASE&System=WIN search for Like Escape Sequence: {escape 'escape-character'} Example: select * from Item where ItemName like 'The *%' {escape '*'} The example will give you all of the entries where the item name begins with 'The *'. This means that you can also search for characters that would otherwise be interpreted as placeholders, such as *, ?, _, % or the period. So in LO you need to escape *, with in direct-sql not. I think it's not a bug, it is how it works. Maybe there was a reason to implement such think in base. -- You are receiving this mail because: You are the assignee for the bug.