EMPTY

This is the best way to check if a value is empty.

It will automatically strip any spaces, tabs, carriage returns etc. from the string before it checks if it is empty.

This command will always return TRUE or FALSE.

Number	Name	Default	Type	Description
1	value		String	Value to be checked
2	zero		Boolean	Include zero and false values as empty

Not Empty Example

Code
Result

<!-- not empty can only be used with within an IF Command-->

{IF(!{EMPTY(HELLO)})}Not Empty{END_IF}<br />
<hr/>
{IF(!{EMPTY('')})}Not Empty{ELSE}Empty{END_IF}<br />

Not Empty

{EMPTY(HELLO)}<br />
<hr/>
{EMPTY('')}<br />

FALSE

True/False Example

Code
Result

<!-- Neither True or False are empty-->
{EMPTY(True)}<br />
<hr/>
{EMPTY(False)}<br />

FALSE

Variables Example

Code
Result

<!-- Check if a variable is empty -->

{VAR(V_EMPTY, '')}
{EMPTY(V_EMPTY)}<br />
<hr />
{VAR(V_NOT_EMPTY, X)}
{EMPTY(V_NOT_EMPTY)}<br />

FALSE

Zero Example

Code
Result

{EMPTY(0)}<br />
<hr/>
{EMPTY(0, TRUE)}<br />

FALSE

TRUE

to add a Comment.

IF Commands

COMPARE
ELSE
ELSE_IF
IF
IIF
TOT_IF

VARIABLE Commands

ADD
ARRAY_CLEAR
ARRAY_JOIN
ARRAY_JSON
ARRAY_QTY_IN
ARRAY_SIZE
DDQUOTE
GET
GET_XML
IS_SET
ORDINAL
SET
SET_XML
VAR
VARS

ULTIMATE DATABASE

HIGH QUALITY BESPOKE SOFTWARE DEVELOPMENT TOOL

EMPTY

Not Empty Example

Simple Example

True/False Example

Variables Example

Zero Example

IF Commands

VARIABLE Commands