I want to be able to take the max of a column and add one to it but it returns as a string and has to be cast as an integer. However, this query: SELECT max(cast(stn.id,integer)) FROM Object Stn doesn't work and only gives me an error telling me the query couldn't be executed. What's the correct way of selecting the maximum on a cast?