# Filter Expressions - Number

## Example

``a.population:             ### SQL interpretation ###- 'any'                   #'any' = 'any'- '100'                   #a.population = 100- '105, 110, 115'         #a.population IN (105, 110, 115)- '> 100'                 #a.population >  100- '>= 100'                #a.population >= 100- '< 100'                 #a.population <  100- '<= 100'                #a.population <= 100- '[100 , 200]'           #(a.population >= 100) AND (a.population <= 200)- '[100 , 200)'           #(a.population >= 100) AND (a.population <  200)- '(100 , 200]'           #(a.population >  100) AND (a.population <= 200)- '(100 , 200)'           #(a.population >  100) AND (a.population <  200)- 'null'                  #a.population IS NULL- 'not 100'               #NOT (a.population = 100)- 'not 105, 110, 115'     #NOT (a.population IN (105, 110, 115))- 'not [100 , 200]'       #NOT ((a.population >= 100) AND (a.population <= 200))- 'not [100 , 200)'       #NOT ((a.population >= 100) AND (a.population <  200))- 'not (100 , 200]'       #NOT ((a.population >  100) AND (a.population <= 200))- 'not (100 , 200)'       #NOT ((a.population >  100) AND (a.population <  200))- 'not null'              #NOT (a.population IS NULL)``

## Description

ExpressionDescription
anyis any value (same as no filter)
100is exactly 100
105, 110, 115is one of the values 105, 110 or 115 exactly
> 100any value greater than 100
>= 100any value greater than or equal to 100
< 100any value less than 100
<= 100any value less than or equal to 100
[100 , 200]interpreted as 100 <= x <= 200 where the endpoints are included
[100 , 200)interpreted as 100 <= x < 200 where 100 is included, but 200 is not included
(100 , 200]interpreted as 100 < x <= 200 where 100 is not included, but 200 is included
(100 , 200)interpreted as 100 < x < 200 where the endpoints are NOT included
nullhas no data
not nullhas data