Previous Topic

Next Topic

PadAcctNo - SQL Function

PadAcctNo(BankAcct: String, Pattern: String[, PadCharacter: String]): String

Creates a bank account number based on the BankAcct string and Pattern string. If PadCharacter is not specified, the character used to pad defaults to 0.

PadAcctNo function syntax has these named arguments:

Parameter

Description

BankAcct

Required. The bank account to be padded.

Pattern

Required. The format of the bank account number. The bank account format is separated by the . character, such as "2.4.8.2".

PadCharacter

Options. The character to pad the bank account string with. If not entered, defaults to zero. Some banks require a space character.

For example:

  PadAcctNo("123-123-55555-22","4.4.8.2")

Returns: 012301230005555522

See Also

SQL String Functions

Book Contents

Book Index