> The portable (and correct) way to do it is to use the DEFAULT keyword > like this: > > INSERT INTO some_table (id_field) VALUES (DEFAULT); Alternatively, for columns for which you have no value, don't specify them at all in the insert. -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxx http://www.killerbytes.com/ (303) 722-0567 voice
