Hi everybody,

I'm using the following insert statement:

insert into curOutput (nSeq, cAccount_Number, cPatient_Name, ;
dDOB, cSSN, cCarrier_Name, cPolicy_Number, dDischarge_Date, ;
cVisit_Type, yCharges, yBalance) ;
values (m.lnSeq, curProcess.cJzanus_Account_Number, curProcess.cPatient_Name, ;
curProcess.dDOB, curProcess.cSSN, curProcess.cCarrier_Name, ;
iif(empty(curProcess.cPolicy_Number), ;
curProcess.cCaid_Number, curProcess.cPolicy_Number), ;
ttod(curProcess.tDischarge_Date), ;
icase(curProcess.cVisit_Type = 'O', 'OUTPATIENT', ;
curProcess.cVisit_Type = 'I', 'INPATIENT', ''), ;
curProcess.yTotal_Charge_Amount, ;
curProcess.yCurrent_Balance_Amount)

cPolicy_Number is a character C(25) NULL field.

Now, when I output this field to Excel I see only one character instead of the whole number. The number begins with M if this gives any clue.

I'm using copy to (m.tcXLSFileName) type xl5 to produce an Excel file and then apply some additional formatting.

Do you know why may I see this strange result?

I've added password protection to the file.

Thanks a lot in advance.