>Ok I put this code in but now on the SQLEXEC insert I get an error message as follows "Arithmetic overflow error converting numeric to data type varchar"
>
>Thanks Again !
Stephen,
Sorry rereading the code I've sent I made a mistake:

Select * from myTable into cursor crsTransfer readwrite
update crsTransfer set myMemo = "0x"+strconv(myMemo,15)
SQLPREPARE(m.nHandle,"insert into myTestdata..myTable (field1,field2,imageField) values "+;
 "(?crsTransfer.field1,?crsTransfer.field2,?crsTransfer.myMemo)")
scan
SQLExec(m.nHandle)
endscan

Cetin