OraFAQ Forum: SQL & PL/SQL » varchar=numeric in where clause

Home » SQL & PL/SQL » SQL & PL/SQL » varchar=numeric in where clause

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

varchar=numeric in where clause [message #38099]

Wed, 20 March 2002 08:54

Bill Droogendyk
Messages: 2
Registered: March 2002

Junior Member

Folks:

I'm having a problem with a varchar=numeric in a where clause. I use the to_char(numeric)=varchar syntax, but the varchar has leading zeros. I've also tried to_char(numeric,'0000000')=numeric to no avail. Any other suggestions?

Your help is appreciated!

Bill Droogendyk

Report message to a moderator

Re: varchar=numeric in where clause [message #38108 is a reply to message #38099]

Wed, 20 March 2002 23:48

seng
Messages: 191
Registered: February 2002

Senior Member

This is caused by program logic. This code should asign as this way

varchar = to_char(numeric)

to allow varchar have input from to_char(numeric). so vachar will have input. Hope this is helping

Report message to a moderator

Previous Topic:	drop user
Next Topic:	how to use floor(to_number(substr(x))) in where clause?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 23:20:39 CDT 2024