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;
|
How to Cast Blob or Clob to varchar in Teradata
|