Lathrop Preston on Tue, 06 Apr 2004 11:28:04 -0500


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [ciapug] MySQL table data - "1" and "01" different values


ok based on what Champ dug up.

this should work (store car_num as VARCHAR(3))

SELECT car_num, CAST(car_num AS INT) AS cn_int, [any other fields] FROM the_table [WHERE whatever] ORDER BY cn_int

Lathrop
_______________________________________________
ciapug mailing list
ciapug@xxxxxxxxxx
http://cialug.org/mailman/listinfo/ciapug