max value using sql

can any help me out in finding out the max value using sql in a field

Try this :

VB Code:

"SELECT MAX(ColumnName) FROM TableName"