If you are using MS SQL you can use the CAST function to change
datatypes
>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
------------------------------------------------------------------------------
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.