change values in the field

[arulsettu]

Hi

i have a field like this

instead of S and I i have to display store and individual ho can i do that? thanks.....

[sunilkumarqv]

Hi,

try this

pick(match(CustomerType,'S','I'),'store','indivisual')

Regards

Sunil

[arulsettu]

HI Manish

my QV key was expired.. sorry i cant open the file u posted can u please paste the code...

thanks

[arulsettu]

Hi

i got this error

Field not found - <Individual>

SQL SELECT CustomerID,

    CustomerType

FROM `Sales_Customer` can yaou correct my mistake.. thnks..

[arulsettu]

thanks to all its working....

[arulsettu]

Thank you very much Manish...