I have a field used to hold the number of a publication's volume series. The field is defined as type string, since in most cases it's used as a string and I'm not doing any calculations with it.
How can I find the numerical maximum of the field and not the alphabetic maximum? I want...
3 < 17
"17" < "3"
I can convert the field to be type integer, but I wondered if there's a trick with the maximum method that I could use. I tried passing 'CAST(number AS UNSIGNED)' to the conditions option. But it didn't change the result.
Thanks in advance,