15.00 - 5764 String functions like INDEX and TRIM are not allowed on LOBs. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

5764 String functions like INDEX and TRIM are not allowed on LOBs.

Explanation:

String functions like INDEX and TRIM are not allowed on LOBs.

Generated By:

OPT modules (optwexp).

For Whom:

End User.

Remedy:

Cast the LOB as a VARBYTE or VARCHAR.