IsValidBTW

The IsValidBTW() function checks whether the input parameter is a valid VATIN format.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Note: this function only works for VATIN from the Netherlands

Returns true if text is indeed a valid VATIN.

Returns false if text is not a valid VATIN.

Syntax

IsValidBTW(text)

IsValidBTW("NL111222333B01") => True

IsValidBTW("12345678900") => False

Parameters

Name	Type	Required	Description
text	text	☑️	BTW number to be validated.