前ゼロ埋めちゃうってのもあったね。

mysql> select if('0100' >= '1', 'Yes', 'No') as douyo;
+-------+
| douyo |
+-------+
| No    | 
+-------+
1 row in set (0.02 sec)

mysql> select lpad('0100', 10, '0') as kouyo;
+------------+
| kouyo      |
+------------+
| 0000000100 | 
+------------+
1 row in set (0.01 sec)

mysql> select if(lpad('0100', 10, '0') >= lpad('1', 10, '0'), 'Yes',
'No') as de_douyo;
+----------+
| de_douyo |
+----------+
| Yes      | 
+----------+
1 row in set (0.00 sec)

mysql> 


--------------------------------------
Yahoo! JAPAN - Red Ribbon Campaign 2006
http://pr.mail.yahoo.co.jp/redribbon/