Converts a value of any data type to a Long value.

This function is similar to CLng in Visual Basic. The result of the conversion depends on the data type of <value>, as follows:

Boolean: The return value is 1 (True) or 0 (False).

Categorical: If the categorical value contains one category, the return value is the category value. Otherwise an error occurs.

Date: The return value is the whole number part of the floating-point number used internally to represent the date.

Double: The return value is <value> rounded to the nearest whole number except when the decimal places are exactly 5. In these cases, it rounds to the even integer. This means that of the two possible rounded values, the one that has an even number as the last significant digit is returned. For example, 14.5 is rounded to 14 rather than 15.

Long: <value> is returned unchanged.

NULL values: If <value> is NULL, the return value is 0.

Object: If the object has a default property, the value of that property is converted. Otherwise an error occurs.

Text: The string is parsed according to the locale to extract the value. An error occurs if the string does not contain a properly formatted integer.

For an example of using CLong in SQL queries, see I want to use the Data Model to access data, but I am used to SPSS-style data. Can you give me an overview?.