I don't know if this can be done or not.
I have a field in a query that always starts with a letter, and is followed by 1 to 7 numbers. I need to insert 0's after the letter so the result is 7 characters long.
D123 --> D000123
E01 --> E000001