## Syntax
```mermaid
%%{init: {
'theme': 'base',
'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' },
'themeVariables': {
'fontSize': '11px',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start((START)) --> IS_IBAN[IS_IBAN]:::quoted
IS_IBAN --> End((END))
```
## Purpose
The `IS_IBAN` SQL function evaluates to `true` when the value provided can be a valid IBAN account.
Parameters:
- Value (`varchar2`): value to test.
- Remove space (`boolean`): whether spaces should be removed before IBAN validation.
Returns: whether the value provided can be a valid IBAN account as a `boolean`.
## Examples
The following example verifies conformance of an IBAN account:
```sql
select is_iban('NL25 BUNQ 2098 2586 07')
----------------
false
```
The following example verifies conformance of an IBAN account with spaces removed:
```sql
select is_iban('NL25 BUNQ 2098 2586 07', true)
----------------
true
```
The following example verifies conformance of an IBAN account:
```sql
select is_iban('NL25BUNQ2098258606')
----------------
false
```