Compare input parameter between two column values?

[Vandy02]

I have a table with two columns

column1 BREAKSTART
column2 BREAKEND


These columns correspond to a break time...
i.e.
BREAKSTART = 1400
BREAKEND = 1430

I want to be able to pull records that an input time of 1435
would not fall within.....
basically where the input time is not between the column times...

thanks

 

[lewisp]

[tt]SELECT something
FROM table
WHERE :inputtime NOT BETWEEN BREAKSTART and BREAKEND[/tt]