Hi Experts............
I want to pick a field from the table,
which has F4 .
For E.g
GENDER TEXT
0 unknown
1 MALE
2 Female
if i write a select for this ,
its fetching me the Gender no.
but i need the TEXT of it.i.e I want to select the high value ......
can it be done only FM or other way possible...
if so pls do let me know'
Thnx
Rachel