EQUALS
All functions > COMPARISON > EQUALS
Returns TRUE if the first value equals the second value
Syntax
EQUALS(expr1, expr2[, digits])sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
expr1 | BIGINT | Yes | First value to compare |
expr2 | BIGINT | Yes | Second value to compare |
digits | BIGINT | No | Optional decimal precision for numeric comparisons |
Returns
BOOLEAN - TRUE if values are equal, FALSE otherwise, NULL if either value is NULL
Notes
- Both values must be of the same or compatible types
- NULL comparisons always return NULL (three-valued logic)
- For strings, performs case-sensitive exact match
- For numeric types, supports optional decimal precision
- For dates/timestamps, compares exact date and time values