>Dear Experts
>
>Table1 has only one field as
>
>code c(7)
>
>data in table is as follows
>
>1
>11
>1101
>1102
>1103
>12
>1201
>13
>1301
>1304
>
>How to findout max code in 2 digits starting with 1
>
>The answer is 13
>
>Please help
How about
SELECT MAX(0000000+EVALUATE(LEFT(code,2))) FROM table1