Hi Todd,

>That will pad with spaces. What do I need to do?

I don't know much (in fact, almost nothng *g*) about separate databases. But if you have any other character you can use to pad the string, what about PADR("CERT",10,CHR(whatever))?

Christof