Keeping leading zeros in a CSV extract from Crystal

Hi there
We are hoping to use Crystal Reports as an extract tool from a SQL database, and so far so good.  The problem I am having is, I have a varchar field that contains significant leading zeros and when I export that field to a CSV file, the zeros are dropped.  Is there a way in Crystal to preserve the zeros?  The preview crystal reports shows it but it gets dropped when the CSV file gets created....any help would be greatly appreciated.
thanks
Wendy
wendelinaAsked:
Who is Participating?
 
mlmccCommented:
Have you tried formatting the field as a TEXT field

ToText({DatabaseField}, "0000000000")

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.