SQL question

Hallo,

if I have the following table:

Nr Text
-- ----

1     'Text1'
2     'Text2'
4     'Text3'

I want to search for the first 'free' Nr, which should be 3 in this case. How to do it with one select?
Thank you in advance!

Burkhard Schultheis
Tele Data Received on Sat Dec 26 1998 - 01:29:36 CST