Re: Is there any way to change case in Informix

Hi Cho, to answer Your question: No, there is nor an upper, neither a lower-function with the SQL. However you might use a workaround for a case-insensitive search: 1. field MATCHES "[Nn][Oo] [Cc][Aa][Ss][Ee]" 2. Store values as Uppercase or Lowercase in the database. Hope this helps. Roland Cho Jia Yang wrote: > > Hi everyone, > > Sorry for this question, I know it is a very simple question but I'm new > to informix and is still waiting for my informix SQL manual to arrive. > > The question is what are the functions provided by informix for changing > case of data. E.g. Uppercase, Lowercase. > > I am trying to do a select statement to search for a value in whatever > case it is in. For example in Oracle I can enter a SQL like this; > > SELECT * FROM MYTABLE WHERE UPPER(Myfield) LIKE 'HELP%'> > Does Informix has any of such function. If not, is there any work > around beside converting all my data to uppercase. > > thanks in advance. > > Regards > A.J.