> I am rewriting a site that cant lose any of the information in
> the tables.
> At one point some one made three fields for the date named Month,
> Day, and
> Year. When they did this they set the fields to VARCHAR(40) instead of
> number.?! :-/
>
> Now when I do an order by month day year it tries to alphabetize:
> 1/12/99
> 11/14/99
> 2/10/99
>
> instead of ordering numerically.
> 1/12/99
> 2/10/99
> 11/14/99
>
> Any one have an idea on how to deal wiht this? I was told the field would
> have to be empty to change from varchar to number in Oracle.
To be safe, I would suggest making new field which are int, then copy the
Val(varchar) fields over, then drop the varchar fields (once you're sure the
data is correct), then rename the int fields...
Long winded, but you can check it every step...
HTH
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
> -----Original Message-----
> From: Art Broussard [mailto:[EMAIL PROTECTED]]
> Sent: 15 May 2000 15:39
> To: [EMAIL PROTECTED]
> Subject: help converting varchar to number
>
>
>
> Thanks
>
> Art
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
