## Syntax
```mermaid
%%{init: {
'theme': 'base',
'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' },
'themeVariables': {
'fontSize': '11px',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start((START)) --> | | VIES_EU_VAT_ADDRESS[VIES_EU_VAT_ADDRESS]:::quoted
VIES_EU_VAT_ADDRESS --> End((END))
```
## Purpose
The `VIES_EU_VAT_ADDRESS` SQL function evaluates to text of the address linked to the EU VAT account provided (when the EU VAT account is valid and active). Each validation takes approximately 250 ms and uses the VIES service offered by the European Union.
See also [[IS_VIES_EU_VAT]], [[VIES_EU_VAT_COUNTRY]] and [[VIES_EU_VAT_NAME]].
Parameters:
- Value (`varchar2`): value to test.
Returns: address associated with the EU VAT account. `null` when not a valid/active EU VAT account.
## Examples
The following example retrieves the address linked to the EU VAT account `NL812602377B01`:
```sql
select vies_eu_vat_address('NL812602377B01')
-------------------
BIESTEWEG 00011
3849RD HIERDEN
```
The following example shows that a `null` EU VAT account evaluates to `null`:
```sql
select vies_eu_vat_address(null)
-------------------
```