Platform: Not Platform Related
Category: File Operations
Selecting even values from a column of data.
Is it possible to select all the records from a column that have an even number?
The way to achieve this is to use the MOD operator. An explanation of the MOD operator can be found here-->. Selecting even values from a table would be performed like this:
Column name MOD 2 = 0
Output would look similar to this: