I am creating a query where fields are all fixed width. When the field is numeric I fill the field with zeros, when the field is text, I fill it with empty spaces. The problem here is that the empty spaces get added before the text, but I want the empty spaces to get added after the text, meaning left - aligned. Anyone have any ideas??
Tks,
Sparx
Tks,
Sparx