Avatar

Correct answer by
Community Advisor

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

View solution in original post