Returns true if the argument is an odd value. Argument can be an Integer, a function returning Integers, or a column reference.

Since the function returns a Boolean value, it can be used as a function or a conditional.

Integer literal value:

isodd('3')

Output: Returns the value true.

Column reference value:

isodd(countStudents)

Output: If the value in the countStudents column is an odd number, then return true

isodd(int_value)


ArgumentRequired?Data TypeDescription
int_valueYintegerThis value can be an Integer, a function returning an Integer, or a column reference.

int_value

Name of the columns, expressions, or literals to compare.

Required?Data TypeExample Value
YesColumn reference, function, or Integer literal valuemyColumn

Example - Basic Equal and Notequal Functions