convert short to string datatype

Avatar

Avatar

rupesh12

Avatar

rupesh12

rupesh12

27-01-2020

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

28-01-2020

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

Answers (0)