Re: help converting varchar to number

2000-05-15 Thread Dan Blickensderfer
ED] [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

Re: help converting varchar to number

2000-05-15 Thread Won Lee
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