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,