>Just some ideas:
>- Set a flag field for sorting, and on that record you like at top, set a number or a char or simply a logical field (if all are .T. and the top record .F. this can be sorted ascending or descendig like you want)
>- Use a char Like . or _ or whatever you want, and at the report field that show the record, put a substr() function.
We didn't want to change something in the table structure. To fit that need, we ended up to put a dot in front. At edit time, we show that field instead of a data entry field as it shouldn't be changed. So, once a record created with that requirement, the value of that field will remain as is. So, it'll always appear on top of the order.