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 Val, as follows:

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

Val is returned unchanged.

The return value is Val 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.

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

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.

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

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

If Val is NULL, the return value is 0.

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?.