RE: BETWEEN CLAUSE---Please Help!!!

RE: BETWEEN CLAUSE---Please Help!!!

 

  

great book to buy
"10 Minute Guide To SQL"
Sam's Publishing
monty6

-------------- Original message --------------
From: "Kaushal Anand " <db2udbdba-ezmlmshield-x97416631.[Email address protected]

> 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
>
>
>
>
>
> ---------------------------------------------------------------------
> 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