Re: case sensitive searches

In article <353A1748.6A646624@syntegra-consulting.com>, Richard Baldwin <rdb@syntegra-consulting.com> writes >Hi all, > >I'm pretty new to Informix database products >but have found myself in a postion where >I'm managing an installation with a number >of Online Workgroup servers. > >I'm trying to find a way/syntax to do case >insensitive comparisons in queries. >So far I have not been successful. > >If anyone one has any info to provide >believe me it will very much appreciated. > You cannot, add an extra column to the table and use it to store the uppercase version of the field you wish to search on. Then search on this new field instead. >TIA, > >-- Richard >rdb@syntegra-consulting.com > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care