2 Replies Latest reply: May 15, 2014 10:07 AM by Rebekah T RSS

    Need a branch number from acct number

    Rebekah T

      I have account numbers ranging from 8 to 10 characters, and I only need the first 3 characters on the ones with 10 and only the first 2 on the 9 character ones, and then one character on the 8 character guys to create the branch numbers. Do I need to make the account number field a 10 character field and then strip 8 characters off from the right? If so, how do you fill the field to get the lead zeros, and does this need to be a character field or can I stick with numeric?

       

      I could use this A LOT if I understood it, so I am hoping it is a simple one -

      :o

      Rebekah T