>Hi All:
>
>Consider the following table:
>
>
>Name Serial_Num
>Joe 001
>Blo
>Moe 002
>Curly
>
>
>For whatever reason, not every record has a serial_Num. I now want to add a record for 'Abe' that will contain the next serial_num, '003'.
>
>How can I retrieve the '002' with SQL similar to:
>
>
>Select bottom serial_num where !empty(serial_num)
>
>
>The problem is that there is no 'bottom' keyword. How do I do it?
>
>Thanks,
>
>Yossi
Try
select top 1 serial_num from tablename order by serial_num desc where !empty(serial_num)
HTH
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham