title: Concatenate two fields
body: <p>I have these two fields in a dataset. How can I concatenate these in Crystal Reports to display next to each other?</p>
  
  <pre><code>select 
    CAST(T.GLTR_PSTNG_TYPE AS VARCHAR) REF_NO, 
    CAST(T.GLTR_DOC_CODE AS VARCHAR) GLTR_OUR_DOC_NO    
  from dom
  </code></pre>