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
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
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: [
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
4 matches
Mail list logo