I'd like to keep it in one field if possible since that's how their database is now and data will be going back and forth.
Plus there should be allowed two of the same numbers, so like: AL00003 KY00003 So any state with more than one record can be sequential and not jump around like KY00003, AL00004, KY00005, etc. Make sense? --- "Chris W. Parker" <[EMAIL PROTECTED]> wrote: > J J <mailto:[EMAIL PROTECTED]> > on Wednesday, March 10, 2004 3:46 PM said: > > > Any ideas? Thank you in advance! > > does it all have to be in the same field? can you > not just combine two > fields? > > one field would be called 'id' and it would be > auto-incrementing. > second field would be 'state' and it would contain > the two letter > abbreviation. > > i can think of a few other ways to get it all into > one field, but > they're a bit less efficient. then again i'm no sql > expert. > > > > chris. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > __________________________________ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
