Perform advanced searches in SELECT statement

[ktsirig]

Hello all
I wanted to ask if there is a way of inserting some mathematics in an SQL select statement.
What I am interested in is to select all rows from a table where 56<ID<67 for example.

Thank you