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

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

Thu, 21 March 2002 07:49

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Another option which doesn't introduce another function call is to just add FM to the beginning of your format mask:

varchar2 = to_char(numeric, 'FM0000000')

Previous Topic:	Re: varchar=numeric in where clause
Next Topic:	NVL versus IF...THEN

Goto Forum:

]

Current Time: Thu Apr 25 03:46:15 CDT 2024