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.
The BOOLEAN function has the following format:
BOOLean(number | string)
The BOOLEAN function accepts either one of the following two parameters:
number (number)
string (string)
The BOOLEAN function returns one of the following string values:
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"
Copyright © 2010 CA. All rights reserved. | Email CA about this topic |