Can I autoincrement a value in the form :-
2001-00002
Regards,
Sacevoy ~:-)
how do you mean? you can set up a column while creating a table that auto-increments. do you want a column that adds a number with each new entry?
that's a string, not a number, so no.
Autoincrement is for numbers only and should not MEAN anything...your data is probably a record number, or something similar that has meaning. Autoincrement should be used for primary keys only.