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

soazine_at_erols.com (Phil Powell) writes:

> 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

Use to_char() to convert the integer field to a varchar2?

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!