I need to check for the following condition:

```
lower_limit <= VALUE < upper_limit

```

I can do the above using 

```
Model.where("lower_limit <= ? AND upper_limit > ?", value, value) 

```

but how do I do the same using ranges ? (..)/(...)

Please note the operators:

The first operator of between is "<=" and second operator is ">". 
Had they been same, I could have used (..) or (...).