Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I compare Varchar2 column field to Integer column field?

Re: How do I compare Varchar2 column field to Integer column field?

From: Ubiquitous <weberm_at_polaris.net>
Date: Sun, 11 May 2003 18:25:47 -0500
Message-ID: <mOmdnXke_t1mRiOjXTWcow@comcast.com>


In article <1cdca2a7.0304151426.61c7a40b_at_posting.google.com>, soazine_at_erols.com wrote:

>How do I compare a Varchar2 column field to an Integer column field,
>especially when the Varchar2 column field may or may not contain an
>integer?

Why would you want to compare them?

In any event, us to_char on the Integer to make it a Varchar type.

-- 
======================================================================
ISLAM: Winning the hearts and minds of the world, one bomb at a time.
Received on Sun May 11 2003 - 18:25:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US