10 digit numbers

J

jkjmwilliams

I have a number that will be pulled up in a query that I would like to be 10
digits, with the leading black places as zeros. How do I get the zeros in
there?
JoAnn
 
S

Steve

There are NO NUMBERS that begin with 0!!! All you can get is a 10 character
yext string that contains only numeric characters. That's what Jerry is
showing you.

Steve
[email protected]
 
J

jkjmwilliams

Thanks Steve for the tip about numbers and strings. Yes, I had the field
saved as a number. Changed it to text and things worked a lot better.

Thanks Jerry for the SQL statement. It worked great after I changed my field
to text.
 
Top