Re: Case insensitive SELECT statment

In article <345F1281.62D2F03C@kmpinternet.com>, danny@kmpinternet.com says... > Anyone no how to perform a select statement which isn't case sensitive? > > In SQL Server i'd use the following: > > SELECT * FROM myTable WHERE myColumn LIKE '%hello%'> > But it doesn't seem to work in Informix > > Any ideas? > -- > Thanks > ------ > > Danny Codling > IT Support Engineer > > KMP Internet Solutions > Regent House > Stockport > Cheshire > SK4 1BS > Tel: +44 (0)161 429 6590 > Fax: +44 (0)161 476 6710 > > http://www.kmpinternet.com > > > Try looking in http://www.iiug.org/software/software_index.html#ISQL you will find a couple of links to stored procedures that you can use to convert the data in your column to uppercase, then all you need to do is to do you like using uppercase. Hope this helps Michael J. Erickson