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.

peace
si

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


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




Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129qcrlk3/M=295196.4901138.6071305.3001176/D=groups/S=1705115386:HM/EXP=1090361219/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=905354396>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/ <http://groups.yahoo.com/group/firebird-support/>


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




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