I am just starting to play with XML.. what im doing is this
SELECT * from c:\acsource\data\employee WHERE em_id = '0000001' INTO CURSOR q1
CURSORTOXML('q1','lcfile',2,0,0)
XMLTOCURSOR(lcfile,'q2',0)
sele q2
scatter memvar
insert into c:\temp\employee from memvar

the problem in i get an operater operand type mismatch

What it is doing is taking char fields that have numeric values like em_id above and making them numeric in the XML

any help would be appreciated.