How to Cast Blob or Clob to varchar in Teradata
We can use cast function to convert blob or clob to varchar. In this example SqlTextInfo column is blob type that converted to varchar.
Example:
Select top 10 cast(substr(t.SqlTextInfo, 1, 500) AS VARCHAR(500))
from PDCRINFO.DBQLSqlTbl_Hst as t;