Re: SQL Query and convertions

Try casting the field in the select statement... select myIntField::char(10), myCharField::integer from ?; liebherr wrote in message <357EBA25.2D40871F@rmcnet.fr>... >Could someone help me in converting string to numeric and numeric to >string in the SELECT CLAUSE of an SQL Query. >I know there is a CONVERT function in Microsoft SQL Server that works >like that : >SELECT CONVERT(CHAR(3), column1) columns one beeing an integer. >Does a similar function exist in INFORMIX ? > >Thanks in advance for your help. > >Gilles Bollecker. >LIEBHERR France. >