Hi,
I am using the MS SQL SERVER 2000 with php. I have a table region
which fields are
- id char (2),
- description varchar(100);
The input of tables are as follow:
Id Description
3 London
4 abc
13 xyz
12 tyx
I need the max value from id which field type is char.
I am using this query
select max(id) as maxValue from region;
but its give me wrong result. Can anybody help me?