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

Re: help converting varchar to number

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

RE: help converting varchar to number

2000-05-15 Thread Philip Arnold - ASP
essed. 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: [

help converting varchar to number

2000-05-15 Thread Art Broussard
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 alphab