Leading zeros

Results 1 to 2 of 2

Thread: Leading zeros

  1. #1
    Join Date
    Dec 1969

    Default Leading zeros

    I have invoice numbers that are required to be displayed with leading zeros. 112 like 000112 and I need to do it in the SQL Query.<BR><BR>i&#039;m trying to make something like this work:<BR><BR>SQL = "SELECT Right("000000" & InvoiceID, 6) FROM main"<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Leading zeros

    hint: LEN(invoiceId)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts