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;