I need to export data to a text file with a fixed record length. Positions 13-25 of the record contain price information and needs to contain leading zeros. My query is fine except that it produces leading spaces instead of zeros. How can I format the price to have leading zeros?

what is the destination field definition. Leding zeros will not be stored
in Money, decimal or float datatypes.

If the definition is a character field then I would do this using an ActiveX
transform

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"cjl" <anonymous (AT) discussions (DOT) microsoft.com> wrote

leading zeros. My query is fine except that it produces leading spaces
instead of zeros. How can I format the price to have leading zeros?