Re: Case sensitivity & Informix SE

}garry wrote: }> }> Hi, }> }> Is there a way to make "like" or "matches" comparisons case }> insensitive. Sybase has functions called "lower" & "upper" to change }> the case of a string, the contents of a variable or the contents of a }> column. Oracle also has similar functions, but I don't remember their }> names. }> } }Hi Garry, } }the functions in Oracle are called "lower" and "upper", too. And I also did }not find any hint in the manuals to a function in Informix, that does the }same. Is it possible, that they don't have an equivalent ? I can't believe }it ! } }Cheers, }Dirk Dirk, Believe it !!!! Garry, Check out the newsgroup archives at http://www.iiug.org, and search on something like "case sensitive". A few months ago there were a few solutions posted to just this question, including a nifty stored procedure. HTH, Richard.