have you try using the datatype YEAR for you table field/column ?
----- Original Message -----
From: "John Berman" <John_Berman@stripped>
Sent: Monday, February 19, 2007 11:45 AM
Subject: Year - Field type
> Using mysql4
> Sure this is an easy one a field in my dbase is year of birth, its always a
> 4 digit number, for some reason Im failing to sort by the field in my
> results, it was originally a varchar field so I updated it to int but still
> no luck. Pointers appreciated.
> John Berman
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1