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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
