Re: SELECT Question

yes i am doing it that way now, but though there may be another way ...
more out of curiosity

thanks anyway

Lada 'Ray' Lostak wrote:

>>>Is there an easy way to write a select statement that returns me the
>>>frist free number or any within the range of 200?
>>>For example if 1-30, and 32-50 are occupied then i would like to fill in
>>>the new entry with id 31.
>>>I currently do it with a function but I was just wondering if there is a
>>>way without it..
>>>
>>>
>>If I understand well, what something about
>>
>> SELECT min(xxx) FROM table WHERE xxx<50
>>
>>
>>
>After I sent it, I saw I understand bad... Just woke up... Sorry :)
>
>I personally think, you need small procedure do to that, because you want to
>perform condition 'min(xxx)' on "unexisting" columns.
>
>R.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>
>
>