Hope you could help me...

I have a table say [table1] ., in it a column having datatype char of length 10, say [serialno] [char] [10] [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.

Why???

Please help me.

Thanks

Regards
Manu

Because you defined the column as character. Either change the data type or try this
select max(convert(int, serialno)) from table1

From books on line:

Hi,

Just check whether this helps!

-----------Code Snippet Starts here------------
Create Table Tb1 ( sno char(10) )
Go

Insert into Tb1 (sno) values ('1')
Insert into Tb1 (sno) values ('3')
Insert into Tb1 (sno) values ('11')
Go

Select Max(Convert(int, sno) from Tbl1
Go
-----------Code Snippet Ends here------------

Best Regards
Vadivel

http://vadivel.blogspot.com

Thanks for your guidance.

IT IS DONE !!!!!!!!!!!!!!!!!!!!