# Miscellaneous Functions

| Function                                                              | Description                        |
| --------------------------------------------------------------------- | ---------------------------------- |
| [CASE/WHEN](https://docs.pinot.apache.org/functions/misc/casewhen)    | Conditional expression             |
| [ISSUBNETOF](https://docs.pinot.apache.org/functions/misc/issubnetof) | Check if IP address is in a subnet |