JDBC "Max" statement

When I try to execute a string such as: "select max(custnum) from customer", I get a "column not found error". What am I doing wrong?

[vasgaddam]

Hi, It seems that, it assumes the column name as "max(custnum)" and not as custnum. Try with
MAX(custnum).. other wise, just double check with the description of the table..whether that column is there or not..
Sreeni