Subject RE: [firebird-support] Case insensitive select
Author McKenna, Simon (RGH)
What about:

SELECT * FROM table WHERE UPPER( field ) = UPPER ( 'value' )

Of course you can skip the 2nd UPPER if you can pre-process the query.


-----Original Message-----
From: willfordkc [mailto:kevnbon@...]
Sent: Tuesday, July 20, 2004 07:36
Subject: [firebird-support] Case insensitive select

Is there a way to do a case insensitive select statement.
Select * from table where name = 'john'
would match 'john' 'John' 'JOHN' etc.

Yahoo! Groups Sponsor

<*> click here


Yahoo! Groups Links

* To visit your group on the web, go to: <>

* To unsubscribe from this group, send an email to: <>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <> .

[Non-text portions of this message have been removed]