NullIfEqual (PQL)
Returns null if the value of the first parameter is equal to that of the second parameter, otherwise it returns the first paramater
- Returned Output: Variant
- Library: PQL \ Granular \ Logical
- Version: 2023.00.000
- Compatibility: Pyramid Query Language (PQL) data sources
Syntax
NullIfEqual( <Column Variant> , <Column Variant> )
* Click on the function's arguments above for more details on the input values.
Comments
- Each of the two arguments can be any simple or complex logical statement made up of columns, values, other functions that return a result.
- The function returns NULL if the values for BOTH arguments are the same. Otherwise, it returns the FIRST argument value.
- This function can be useful in mathematical statements - especially for division.
- For details on how to employ and use this function see the custom column overview.
Different Function types
- As a granular function, it is used in the base SQL query itself.
Example
This example checks if the values in the case and switch columns below are the same.
NullIfEqual( [custom_attributes].[case] ,[custom_attributes].[switch] )
You can see the effect from this example snippet in column NullIfEqual at position #9, based on the case and switch columns in positions #6 and #7. Note: The NULL value is returned as a double dash.
