Expression = Val ( String )
Converts a string into a boolean, a number or a date, according to the content of the string. The current localization is used to convert numbers and dates.
The conversion algorithm is the following :
TRUE
or FALSE
, then the matching boolean value is returned.
NULL
is returned.
Example :
PRINT Val("09/06/72 01:00") => 09/06/72 01:00:00 PRINT Val("3.1415") => 3.1415 PRINT Val("-25") => -25 PRINT Val("True") => True PRINT IsNull(Val("Gambas")) => True