Thanks,
but that only gives me smallest number of the ones in use but not the
first free number.
Alex
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
>
>Best regards,
>Lada 'Ray' Lostak
>Unreal64 Develop group
>http://www.orcave.com
>http://www.unreal64.net
>
>
>--------------------------------------------------------------------------
>In the 1960s you needed the power of two C64s to get a rocket
>to the moon. Now you need a machine which is a vast number
>of times more powerful just to run the most popular GUI.
>
>
>
>
>
>