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;