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

Autonumbering in user-defined format 1
Autonumbering with user-defined format 1
Insert and propagate Rows - based on a format rule 11
Auto fill numbers starting with zero 3
How do I keep leading zeros and remove the decimal point when expo 2
Expression in SQL or user-defined function? 4
Leading Zeros and Number Datatype? 4
Labeling equations in IEEE format 6

Top