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