Teradata Database Message 3535 - 3535 - Analytics Database - Teradata Vantage

Message

A character string failed conversion to a numeric value.

Explanation

A character string constant in a query is in a context requiring that it represent a numeric value, and it does not.

Generated By

OPT modules.

For Whom

End User.

Notes

It is preferable to use a numeric value rather than a character representation of a numeric value. This avoids the need for conversion and is more efficient.

Remedy

Change the constant to either a numeric value or a character string that represents a numeric value.