Auto generate varchar Ticket number via DB...
- by Rusty
Hello,
I'm looking for suggestion on how to get the DB to auto generate Ticket numbers (preferably via the SQL DB) for a varchar column. I have the following tables in the DB: Activities & Cases and would prefer the format to be "Act000001" or "Cse000001". This would be something similar to the identity column property.
Any suggestion would be highly appreciated.
Thanks.
Rusty