using labkey SQL to calculate next ID in a series

LabKey Support Forum (Inactive)
using labkey SQL to calculate next ID in a series Ben Bimber  2011-06-20 14:28
Status: Closed
 
i dont know what i was thinking with that second SQL idea. please ignore that. any insight into sorting out the character vs digit portion of a string would still be appreciated. thanks.