variable value depend on \'field value\'

[sal1150]

I have field "employee_sex" its value 'F' or 'M'.

I like to let the variable value is 'Female' if employee_sex ='F' or

'Male' if 'Female' if employee_sex ='M'

IF (Female' if employee_sex =='F')

{

MYVAR='Female';

} else

{

MYVAR='Memale';

}
 

 

[Gaby38]

 I prefer do the test in the query, because I am more familiar with sql than java.

select case when employee_sex = 'F' then 'Female' else 'Male' end as Sexe,.......

but it  is  a "classical" test in java:

($F{employee_sex}.equals("F"))?$V{Sexe}="Female":$V{Sexe}="Male" (I am not sure about the exact syntax)