Hi
You can write some 0000000.00 instead of 0 to obtain desired column width

IIF(MLINE(cost2.exclude,13)='1',cost2.addamo3,00000000000.00) as DUTY

>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