title: How to use a TRIM function in SQL Server
body: <p>I cannot get this TRIM code to work</p>
  
  <pre><code>SELECT 
     dbo.COL_V_Cost_GEMS_Detail.TNG_SYS_NR AS [EHP Code], 
     dbo.COL_TBL_VCOURSE.TNG_NA AS [Course Title], 
     LTRIM(RTRIM(FCT_TYP_CD)&amp; ') AND (' &amp; LTRIM(RTRIM(DEP_TYP_ID) &amp; ')' AS [Course Owner]
  </code></pre>