If you are using views to access your data (you are using views,right?;) ) it is a simple matter to create an expression in your view based on the RIGHT function. This method is much easier to work with in VFP 5.0 because you can now name the fields you create in your view.
In the view desiger, add an expression field, something like:

RIGHT(table.field, 8) AS MyField



Michael G. Emmons


>Is it possible to create a two column combo box where both columns are
>based on the same field. The first column is the last 8 characters and
>the second column is the full field. For search purposes the last 8
>characters are used in an index, but it is not necessarily a unique value
>so the full field must also be veiwed.