RE: quick syntax question ...

From: Raj Gopalan <raj.gopalan_at_netdecisions.co.uk>
Date: Tue, 2 Jan 2001 15:23:59 -0000
Message-Id: <10729.125521@fatcity.com>

to_number function.

-----Original Message-----
From: Adam Turner [mailto:ATurner_at_concreteinc.com] Sent: 02 January 2001 14:55
To: Multiple recipients of list ORACLE-L Subject: quick syntax question ...

I want to convert (on the fly) from varchar2 to INT - is that possible? Is there a convert function?

On SQL Server I use TO_INT(fieldname)

thanks

Adam
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Adam Turner
  INET: ATurner_at_concreteinc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 02 2001 - 09:23:59 CST