Re: question from Dummy about SQL syntax.

UPPER? From: Arnaud Touboulic <webmaster@uic.asso.fr> > >i would like to know the syntax in Informix/SQL for the function >"toUpperCase". > >example : select news.* from myTable order by news.messages.toUpperCase; select * from news order by UPPER(messages);________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com