Skip to content

IBAN_VALID

Description

IBAN_VALID checks whether a string is a structurally valid IBAN (International Bank Account Number). It normalises the input (removes spaces, uppercases) and verifies the mod-97 checksum as defined by the ISO 13616 standard. It does not validate the country code or enforce country-specific lengths (it only requires at least 5 characters), and it does not verify whether the account actually exists.

Syntax

IBAN_VALID(iban)

Returns: true if the IBAN is structurally valid, false if it is not, unknown if the argument is not a string.

Example

IBAN_VALID('CH5604835012345678009')

This returns true.

IBAN_VALID('CH0000000000000000000')

This returns false — the checksum does not pass.

IBAN_VALID('ZZ5604835012345678009')

This returns falseZZ is not a recognised IBAN country code.

Example in context

p is Person
IBAN_VALID(p.bank_account_number)

Returns true if the account number entered by the user is a valid IBAN. Commonly used as a condition to trigger a validation error or block case progression until a correct IBAN is provided.