title: How to show CLOB type in a SELECT in SQL Server?
body: <p>I have a table with one column of CLOB type data, they are all very short no more than 20 bytes, however I cannot see the actual string in the CLOB data.</p>
  
  <p>For example if I use <code>SELECT *</code>, under the CLOB type every data is like:</p>
  
  <pre><code>CLOB, 8 Bytes
  CLOB, 15 Bytes
  CLOB, 9 Bytes
  </code></pre>
  
  <p>But I just want to see the content of the CLOB data.</p>
  
  <p>I tried:</p>
  
  <pre><code>SELECT DBMS_LOB.SUBSTR(ClobColumnName, 20 ,1)
  </code></pre>
  
  <p>And it doesn't work, error is:</p>
  
  <blockquote>
    <p><em>Error Code: 4121, SQL State: S1000<br>
    Cannot find either column "DBMS_LOB" or the user-defined function or aggregate "DBMS_LOB.SUBSTR", or the name is ambiguous.</em></p>
  </blockquote>
  
  <p>So can I ask what's the syntax for direct display a CLOB data in a query?</p>
  
  <p>I'm using SQL Server with <code>dbVisualizer</code>.</p>