The only half hearted solution i can think of would be to use the rowid.
That wouldn't be very reliable though, especially if you are deleting rows
from the table. It's about as close to the solution as you can get though. I
think :)
Alan
sjoshi_at_ingr.com wrote in message <891ea5$aqn$1_at_nnrp1.deja.com>...
>Hello
> I have this problem. I have a table (spec_list) with (character) field
>spec_type. Now the data in the table is unsorted and I want to sort the
>data with any specType I add to come first when I do a select * from
>speec_list.
> I'm wondering how I can do this regulary, since there is not date
>field in the table and I always want it to show newly added fields
>first. Is there a way to sort/update the table ??
>
>thanks
>Sunit
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Feb 23 2000 - 17:12:04 CST
