Subject RE: [IB-Conversions] SQL Truncation & error issue
Author Claudio Valderrama C.
Ryan Nilsson-Harding wrote:
> Could somone please make these errors make sense?
> I figured the data type WOULD be known because I'm telling it (CAST
> ... VARCHAR(x))
> Is there a convenient way to carry out this truncation on this one
> table's field alone?

Cast only changes type. You will get a run-time error when the data doesn't
fit in your forced type. You need to apply substring() and then the cast.

BTW, this group is to help people with ideas about converting from XYZ to
Firebird, but you apparently thought it was for data type conversions.
Nothing really bad, but you will get more peer support in firebird-support