I have a table with 3 columns: 

```
Index, Time_start, Time_stop

```

The `Time` columns are of type `time(7)`.

I need a view (or select statement) that will list the three columns along with a fourth column that will state `In` or `Out` if the moment when the script is run is or not between `Time_start` and `Time_stop` for each row. 

I tried using a case statement:

```
case getdate() between Time_start and Time_stop then 'Yes' 

```

but it's not working.