Optimizing SELECT Query

Hello world,

following situation: I have a table T with a column C (C are numbers). I want to find the number which is smaller but nearest to a given value N.

How to formulate this as a select statement in an efficient way?

Thanks,
Carsten.

---
I want to die peacefully in sleep like my grandfather.
Not screaming in terror like his passengers!