Home » SQL & PL/SQL » SQL & PL/SQL » Error when comparing varchar Invalid Number and number columns
Error when comparing varchar Invalid Number and number columns [message #7357] Fri, 06 June 2003 14:40 Go to next message
Confused Analyst
Messages: 1
Registered: June 2003
Junior Member
Error when comparing varchar Invalid Number and number columns. Is it possible to change one column from VARCHAR2 to NUMBER so that I can compare the two columns?

Report message to a moderator

Re: Error when comparing varchar Invalid Number and number columns [message #7358 is a reply to message #7357] Fri, 06 June 2003 15:02 Go to previous message
Vijay
Messages: 116
Registered: September 1999
Senior Member
You should used the TO_CHAR(X) conversion function.

Vijay

Report message to a moderator

Previous Topic: Validating a Social Security Number
Next Topic: easy package problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 18:59:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.