10 digit numbers

  • Thread starter Thread starter jkjmwilliams
  • Start date Start date
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
 
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
(e-mail address removed)
 
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.
 
Back
Top