Re: LIKE case-insentive ?
Frank Schönheit - Sun Microsystems Germa ny <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
Hi Andrew,
> Here I decided maybe I should look at the HSQLDB docs again...(novel
> idea, hey) and this is what it says about like
>
> "The LIKE keyword uses '%' to match any (including 0) number of
> characters, and '_' to match exactly one character. To search for '%' or
> '_' itself an escape character must also be specified using the ESCAPE
> clause. For example, if the backslash is the escaping character, '\%'
> and '\_' can be used to find the '%' and '_' characters themselves. For
> example, SELECT .... LIKE '\_%' ESCAPE '\' will find the strings
> beginning with an underscore."
>
> great it doesn't even mention the * character... :-D .
:)
For the record:
% is the SQL character, * is the "convinience character" used by OOo to
present it to the user. Internally, when you enter a criterion LIKE * in
the graphical UI, OOo translates this to %. However, this doesn't work
anymore if your expression is more complex - as your "ucase('d*g')".
Ciao
Frank
--
- Frank Schönheit, Software Engineer [email protected] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Database http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -