Art,
You could create a new field "Comb_Date" timedate() data type, and write a
utility to take the three separate fields and combined them into one and
insert it into the Comb_Date field.
Dan
-----Original Message-----
From: Art Broussard <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, May 15, 2000 10:43 AM
Subject: help converting varchar to number
>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.
------------------------------------------------------------------------------
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.
