> ## Documentation Index > Fetch the complete documentation index at: https://docs.less.tech/llms.txt > Use this file to discover all available pages before exploring further. # Functions Returns the first non-null value from a list of expressions. Evaluates expressions from left to right and returns the first one that is not null. If all expressions are null, returns null. COALESCE function

Conditional function/statement that returns one value if a condition is true, and another value if false. Can be nested within other IFF functions for complex conditional logic. Syntax: IFF(condition, value\_if\_true, value\_if\_false). The condition must default to a boolean value (true or false). That means that the statement '"hello"' is not a boolean value. However, \[column]="hello" is a boolean value because it is either true or false for a given row. If column function

Concatenates two or more string values into a single string with a custom separator/delimiter. Combines multiple text values in the order they are provided. Returns an empty string if all input values are null. Concat function

Converts a value to a decimal column type. Handles conversion from strings, integers, and other numeric types. Float function

Converts a value to an integer columns type. Rounds down to the nearest integer when converting from float values. Int function

Converts a text literal or text column to a datetime type. Note that the value has to be without a time component and in this format: YYYY-MM-DD. Date function

Converts a text literal or text column to a datetime type. Note that the value has to be with a time component and in this format: YYYY-MM-DD HH:MM:SS. Datetime function

Logical operator that returns true only if all conditions are true. Typically used within IFF functions or [IF Column](/tools/new-columns/if-column) tool for complex conditional logic. Returns false if any condition is false or null. Each part of the AND function must default to a boolean value (true or false). That means that the statement '"hello"' is not a boolean value. However, \[column]="hello" is a boolean value because it is either true or false for a given row.

Logical operator that returns true if at least one condition is true. Typically used within IFF functions or [IF Column](/tools/new-columns/if-column) tool for complex conditional logic. Returns false only if all conditions are false or null. Each part of the OR function must default to a boolean value (true or false). That means that the statement '"hello"' is not a boolean value. However, \[column]="hello" is a boolean value because it is either true or false for a given row.

Returns a boolean value indicating whether a value is null. Returns true if the value is null, false otherwise. Useful for conditional logic and data validation. ISNULL function

Returns a boolean value indicating whether a value is not null. Returns true if the value has any non-null content, false if the value is null. Useful for conditional logic and data validation. ISNOTNULL function

Returns a boolean value indicating whether a value is true. Returns true if the value is true, false otherwise. Useful for conditional logic and data validation. ISTRUE function

Returns a boolean value indicating whether a value is false. Returns true if the value is false, false otherwise. Useful for conditional logic and data validation. ISFALSE function