BIC_VALID

Info

New in Atfinity 17.

Description

BIC_VALID checks whether a string is a valid BIC (Business Identifier Code, ISO 9362) — the SWIFT code used to identify banks. It accepts both the 8-character (bank + country + location) and 11-character (with branch) forms. It verifies the structure only, not that the bank actually exists.

Syntax

BIC_VALID(bic)

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

Example

BIC_VALID('DEUTDEFF')

Returns true — 8-character BIC.

BIC_VALID('AGRIFRPP882')

Returns true — 11-character BIC with branch code.

BIC_VALID('1GRIFRPP882')

Returns false — a BIC may not start with a digit.