You can use the REPLACE command with some condition.
If you have very many equivalences, you may need a table that lists the desired conversions, and use SET RELATION. You can REPLACE on a field in the other table.
>Dear Sir,
>
>Table1 has two numeric type fields having data as follows
>
>1-0
>2-1
>3-2
>4-3
>5-1
>6-2
>7-4
>8-1
>9-2
>
>For Treeview control, I want to replace the data of second field as follows
>
>1-0
>2-1
>3-2
>4-1
>5-4
>6-4
>7-1
>8-7
>9-7
>
>Please help
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)