UBB.Developers Forums Community Development Programming MySQL and Server Configuration Looking for some SQL help...

I'm trying to devleop a Trouble Ticket forum. I have Most everything working but I need to be able to append a sequentially incremental number to the beginning of the Subject.
So First post would be

#1 - Subject

Second...

#2 - Subject here...

and so on.

I know how to modify the subject line at the time of posting, but my SQL sillz are um...non-existant. Anyone able to give me an idea of how to go about this?

Thanks...

P-