convert short to string datatype

[rupesh12]

Hi,

In update data activity, I'm getting below error:

ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Argument data type smallint is invalid for argument 1 of substring function. SQLState: 37000

Here source field has short datatype and destination has string datatype.

Using ToString(), I tried to convert short to string but its not working.

Please let me know how to resolved the issue.

Thanks

[Jonathon_wodnicki · Accepted solution]

Hi,

Are you using ToString() inside the Substring, and offset counting from 1?

Substring(ToString(@short), 1, 1) works fine in postgres, translates to Substr(text(X0.iShort), 1, 1)

Thanks,

-Jon