If Condition

[upaliwije]

Dear Friends

In my load script I have following line which does not execute

if(POL_TYPE='F' AND IsNull(LAST_PERIOD),'N',IF(POL_TYPE='F' AND (LEN(TRIM(LAST_PERIOD)))>0,'R',if(POL_TYPE='A','R',POL_TYPE)))AS POL_TYPE,

Pls see and advise me whether it is wrong. My requirement is as follows

If POL_TYPE='F' and LAST_PERIOD is null POL_TYPE should be 'N'

If POL_TYPE='F' and LAST_PERIOD is not null POL_TYPE should be 'R'

If POL_TYPE='A'  POL_TYPE should be 'R'

for other records POL_TYPE=POL_TYPE as recorded in the data table

[upaliwije]

Yes

but not working

[anbu1984]

What is the error message?