Re: Uppercase conversion

>On Thu, 13 Mar 1997 16:25:38 GMT, albertob@flash.net wrote: >>Hi, >>I am new to Informix. Does anyone knows how to convert a field to >>Uppercase or to make a query condition not case sensitive? >> >>Thanks >>Alberto >Based upon the responses to this question, doing a true, >non-case-sensitive search is not possible in Informix. Will this be >true of Oracle and Sybase also? > >Currently, the two small databases I have been asked to build in >Informix were all in upper case but the next one may not be. > >Henry Informix does not have an upper function (I asked for one too) but they did provide me with the code to do a stored proc that does the same thing. Simple sort of proc where it takes the argument, stips it down into single letters, does a simple compare (a --> A) and then puts it all back together again and returns the fully uppercase version. Oracle has an upper() function that forces the value to uppercase, I believe they also can force to lower and maybe even stringcase. :) - kat kathy@nvolve.com