Previous Topic: BELOW Function--Is User Below Specified LDAP DN

Next Topic: CHAR Function--Convert an ASCII Value

BOOLEAN Function--Convert to "TRUE" or "FALSE"

The BOOLEAN function converts a number or string value to a string value of either "TRUE" or "FALSE". Numeric values of zero are converted to "FALSE". All other numeric values are converted to "TRUE". String values of "true" or "yes" are converted to "TRUE". All other string values are converted to "FALSE". The BOOLEAN function is not case-sensitive.

Syntax

The BOOLEAN function has the following format:

BOOLean(number | string)

Parameters

The BOOLEAN function accepts either one of the following two parameters:

number (number)

string (string)

Return Value

The BOOLEAN function returns one of the following string values:

Example

Return_value=BOOLEAN('Phoebe')
Return_value="FALSE"

Return_value=BOOLEAN('Yes')
Return_value="TRUE"

Return_value=BOOLEAN(123)
Return_value="TRUE"

Return_value=BOOLEAN(0)
Return_value="FALSE"

More information:

NUMBER Function--Convert to a Numeric Value

STRING Function--Convert to a String


Copyright © 2010 CA. All rights reserved. Email CA about this topic