RE: question from Dummy about SQL syntax.
Don't really know much about the news part but maybe this will help you
SELECT tabid, UPPER(tabname), owner
FROM systables
ORDER BY 2
> -----Original Message-----
> From: Arnaud Touboulic [mailto:webmaster@uic.asso.fr]
> Sent: 22 August 2000 10:03
> To: informix-list@iiug.org
> Subject: question from Dummy about SQL syntax.
>
>
> hi,
>
> i would like to know the syntax in Informix/SQL for the function
> "toUpperCase".
>
> example : select news.* from myTable order by
> news.messages.toUpperCase;
>
> thx in advance
>
> atouboulic@uic.asso.fr
>
___________________________________________________________________________
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
Sema Group.
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.
If you have received this email in error please notify the Sema Group
Helpdesk by telephone on +44 (0) 121 627 5600.
___________________________________________________________________________