----- Original Message ----- From: "Jeremy" <[EMAIL PROTECTED]>
> Min and max select the min or max value that exists in the list. What > I'm looking for is a way to find the mininum number spawngroupID that > isnt in the table, basically the first free one. The database isn't mine > to alter, but I will see if I can get them to make that field > auto_increment. Auto-increment doesn't usually fill in unused values (as you are trying to do), it just counts up. If it's an 11-byte integer, I wouldn't worry about running out of digits any time in the near future. - Robert [To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]
