Bill: that doesn't work for me, get a message when trying to insert the variable into the Real column that "column BillRate must be a valid REAL"
Can I ask: do you ever have Insert statements with variables that could possibly be null? Or do you test them all? Karen > Karen, > > One idea: you could do this: > > > IF vBillRate IS NULL THEN > SET VAR vBillRateText = 'NULL' > ELSE > SET VAR vBillRateText = (CTXT(.vBillRate)) > ENDIF > > > And then replace .vBillRate in your insert with &vBillRateText >
