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;