Hope you could help me...
I have a table say [table1] ., in it a column having datatype char of length 10, say [serialno] [char]  [allow Null]
I have stored 10 values from 1 to 10 in this column.
when i give query ..
select max(serialno) from table1
it gives me maximum value as 9, whereas it has maximum value as 10
and it should give 10 as a maximum value.
It is happining for even when i am putting any value greater than 9.
It does't show that number as a max no. it is showing 9 as max no.
Please help me.