I don't know much about oracle, but i think that's because to_char takes
binary_float as an argument. How about casting startnumber to
binary_float.


Regards,

Anand

-----Original Message-----
From: jeffrey
[mailto:db2udbdba-ezmlmshield-x41013618.[Email address protected]
Sent: Friday, August 24, 2007 12:50 AM
To: LazyDBA Discussion
Subject: BETWEEN CLAUSE---Please Help!!!

Can you use a BETWEEN clause when comparing a VARCHAR column BETWEEN two
data variables that I am changing from FLOAT to VARCHAR? Both have
numbers in the table. Maybe someone can explain why I am getting this
error. Please help!!!!



AND CONTROL_NUM_IDENTIF BETWEEN
COALESCE(ORA.TO_CHAR(Startnumber), '') AND
COALESCE(ORA.TO_CHAR(Endnumber), '')



Error is

"STARTNUMBER" is not valid in the context where it is used.





Jeff Hixson

Oracle Application Specialist

Accenture National Security Services





This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you have
received it in error, please notify the sender immediately and delete
the original. Any other use of the email by you is prohibited.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page