hi, I'm trying to find how I can autoincrement a field in addition to the ID field. Here's the layout.

ID (int, primary, unique, indexed, not null, autoincrement)
PROJ_NUM (int, not null, autoincrement)
PROJ_NAME (varchar, not null)

So i can show something like this:

0023 PROJECT ALPHA
0024 PROJECT BETA
...

Is there a way to do this and to also have the zeros show in the front? thanks.