RE: Convert numeric to char in SQL

Posted in 1998

Ashby, David — Thu, 23 Jul 1998 08:28:01 +1000 — source: Informix-list mailing list archive (1991-1998)

Rick, Try concatenating a blank to the numeric eg: select day || ' ' from calendar. Regards David Ashby -----Original Message----- From: novaboy1@my-dejanews.com [mailto:novaboy1@my-dejanews.com] Sent: Thursday, 23 July 1998 0:29 To: informix-list@iiug.org Subject: Convert numeric to char in SQL Hi, In IUS 9.1 it is possible to execute the following sql statement(day is a char in the calendar table) select (day::numeric) from calendar The result is that the SQL display the expressions, of day, now converted to a char. In Online 7.1, it is not possible to execute the sql script, syntax error??. Does anyone know of a way around this????? Cheers Rick -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum