Autonumbering in user-defined format

R

Roberto Rocco

Hello,

I want to insert auto-numbers in arbitrary text positions. These
auto-numbers should have a user-defined format, e.g.: "TOP 0001", "TOP
0002", "TOP 0003", etc.

So there should be a leading text in front of the number, and the
number itself should have a fixed length with leading zeros.

Is that possible? How?

Many thanks for every hint.

Best regards,

Roberto Rocco.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert and propagate Rows - based on a format rule 4
Auto fill numbers starting with zero 3
How do I keep leading zeros and remove the decimal point when expo 2
Leading Zeros and Number Datatype? 4
Expression in SQL or user-defined function? 4
Concantenate Text with numbers with fixed form 2
Protect Number Format Only 7
Getting 'Next UNUSED Form Number' in sequence. 7

Top