Re: LIKE case-insentive ?
Jonathon Coombes <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Organization | Cybersite Consulting Pty Ltd |
| Message-ID | <[email protected]> |
On Wed, 2005-09-07 at 18:41 -0400, Andrew Jensen wrote:
> Hello Henri
>
> Off the top of my head I suppose you could get the case-insensitive
> part by casting both sides to Upper or Lower case.
>
> SELECT "WORD" FROM "WORDS" "WORDS" where ucase( "WORD" ) LIKE ucase('Fish')
>
> Don't think that will do the trick with accents...but I will keep thinking.
I know that some databases has the two keywords LIKE and ILIKE,
one for case-sensitive and the other for case-insensitive matching.
Does this work at all?
Regards
Jonathon
--
OOo Tips: http://mindmeld.cybersite.com.au/tips.rss
OOo Knowledgebase: http://mindmeld.cybersite.com.au
Training4Linux: http://www.training4linux.com
Cybersite Consulting: http://www.cybersite.com.au