Re: How to select upper case fields??? Pleaes help!!! Thx.

Michael Tran wrote: > > Hi all, > > I would very much appreciate if anyone could help me with this problem > in Informix. > > I have a form with a field that accept both uppercase and lowercase. > This field is a field of type char of course. The problem is that > in a construct statement, the search does not pick up both upper case > and lowercase. This is because the database could contain both upper > and lowercase for this particular field. > If I remember right, there is a function in the FAQ to modify the "WHERE" clause from a construct to make it case insensitive: ABC -> matches "[Aa][Bb][Cc]" -- Mike Aubury _\\?/_ |O O| +----------oOOO-\\_/-OOOo---------+-------------------------------+ | Heisenberg may have been here | mike@aubury.demon.co.uk | | | http://www.aubury.demon.co.uk | +--------------------------------+-------------------------------+