The padleft function should do the trick:
PadLeft([Field1],11,"0")
If it's a numeric field, you would want to add a tostring first:
PadLeft(tostring([Field1]),11,"0")
I know you're thinking, "I'm going to beat Marquee Crew" to the answer." You know what? You beat me!
Happy Friday :)
Mark
Thanks very much for that.
Now if you could just finish up the rest of my broken workflow.. lol.
I'll have to remember that - when all else fails.
You all are brilliant. That's all. Cheers.
I'm new. What data types does this work with? Also, does it matter if it's VW String, VString, String?