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

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 15 Apr 2003 19:57:23 -0700
Message-ID: <92eeeff0.0304151857.1e0bf1fa@posting.google.com>

soazine_at_erols.com (Phil Powell) wrote in message news:<1cdca2a7.0304151426.61c7a40b_at_posting.google.com>...
> I am at a loss as to how to do something this simple.
>
> 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?
>
> Thanx
> Phil

Type cast your INTEGER with a TO_CHAR function. e.g.

FIELD_VARCHAR2 = TO_CHAR(FIELD_INTEGER) Regards
/Rauf Sarwar Received on Tue Apr 15 2003 - 21:57:23 CDT

This message: [ Message body ]
Next message: Agron: "How to talk to LISTENER"
Previous message: Howard Rogers: "Re: Expanded Oracle DBA Site"
In reply to: Phil Powell: "How do I compare Varchar2 column field to Integer column field?"
Next in thread: Tim X: "Re: How do I compare Varchar2 column field to Integer column field?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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