title: TRIM RTRIM LTRIM Performance
body: <p>I am only required to do <code>RTRIM()</code> in some part of query but if i do TRIM() will that affect performance.</p>
  
  <p>Is <code>Trim()</code> 
  Slower/Faster/Exactly same(NOT even has negligible difference) 
  compared to <code>RTRIM()</code> AND <code>LTRIM()</code>?</p>
  
  <p>This is with respect to Oracle 10g ONLY.</p>
  
  <p>But in case of SQL Server 2005,
  Do we have function / method 'x()' such that it can replace <code>RTRIM(LTRIM(' blah.. blah..  '))</code> to a single function ?</p>
  
  <p>I simply mean of having "single" function for doing the same functionality what both <code>RTRIM()</code> AND <code>LTRIM()</code> does.</p>