>In a special request asked by a client, one specific record in the table need to appear on top of the order. So, the field name of that record could be Name. Lets assume it's value is MyValue. But, that value should appear on top of the order when doing a SQL. We do not want to do a special SQL for that as this will imply to change the framework. We would like to benefit of the value of the fields themselves.
>
>So, one simple approach is to use a value such as .MyValue which will put the value on top of any alpha character when doing a SQL. But, that is not good as visibly, we see the . in the field. So, I thought of saving a value of CHR(0)+'MyValue' at save time. That works. The record now appears on top of the SQL. And, the value being displayed is MyValue. However, as soon as we go in edit mode and just do a save, the CHR(0) gets dissappeared. So, we're back to square one. Without having to apply a specific code at save time to always save CHR(0)+'MyValue' for that record, is there a way to benefit of that invisible character in order to keep that record on top of the SQL?

Michel,
Can't you use another column as the sorter ? If not chr(9) might be a better alternative.
Cetin