I have a select statement which populates a cursor. One field in particular which is the IIF statement mlines the exclude field and if 1 it gives the value of another field, this is populated as DUTY. The query runs but why is my DUTY field only 2 characters in length?

SELECT modacad.key1, modacad.key2, modacad.key3, modacad.key4, cost2.addamo1, cost2.calcname, ;
cost2.addamo2, cost2.addamo3, cost2.addamo6, modacad.moc042, modacad.moc045, cost2.addamo4, ;
cost2.addamo7, cost2.addamo11, cost2.addamo12, IIF(MLINE(cost2.exclude,13)='1',cost2.addamo3,0) as DUTY, ;
IIF(MLINE(cost2.exclude,14)='1',cost2.addamo14,0) as Opr, cost2.addamo14, cost2.exclude, cost2.addamo13 ;
FROM "U:\Questpdm\Data\modacad.dbf", "U:\Questpdm\Data\cost2.dbf", "U:\Questpdm\Data\cost2mn.dbf" ;
WHERE cost2mn.mainkey=cost2.mainkey and cost2mn.updmainpg=cost2.page and cost2mn.updmaincol=cost2.calcno ;
AND cost2.mainkey=modacad.mainkey AND modacad.key4='TECHNICAL' AND !EMPTY(modacad.moc042) ;
INTO CURSOR result

Thanks