finally figured out a way around this so for those of you who may also have this problem. In my sql I cast to numeric(8,2) and then cast that to varchar(20) in the following way:
select cast(cast(field as numeric(8,2)) as varchar(20)) from table
I'm fairly certain its a problem with the odbc driver rather than Automation Anywhere as running the same original query through an odbc connection under another piece of software gave me the same truncation. |