using labkey SQL to calculate next ID in a series

LabKey Support Forum (Inactive)
using labkey SQL to calculate next ID in a series jeckels  2011-06-22 18:23
Status: Closed
 
Hi Ben,

Be sure that if you're doing a MAX, you're doing it on a number and not a string. '9' > '100000'

Thanks,
Josh