With the ODBC connector I am trying to move a number into a text field in a DB2 database.

I have tried:

RetVal=str([number])
and

str([number])
but no matter what COIT insists on sending the number as a number and not a string.