Awesome! Thanks a lot! Just so I understand....
concat(substring(field3, 1, 6), substring(field1, 1, 1), substring(field2, 1, 1))
In the section where your defining what you want from the field, i.e. (field3, 1, 6), your basically saying the first through sixth character. Correct?
Thanks again for the ...