LTRIM/RTRIM NOT TRIMMING

• eletuw

  SSCrazy

  Points: 2464

  More actions

  December 12, 2003 at 9:24 am

  #84921

  I use ltrim and rtrim in select statement but the output is not trimmed. The variable are all of datatype varchar.

  select ltrim(rtrim(org_name)),ltrim(rtrim(org_code)) from tableA

  Does any one know what is happenning.

  Thanks for your help.

• ThomasH

  SSCertifiable

  Points: 7437

  More actions

  December 12, 2003 at 9:42 am

  #485984

  Can you post the results of

   
  
  select TOP 1 '-' + ltrim(rtrim(org_name)) + '-' 
  
  from tableA? 
  
  

  Might also have some unprintable or CR/LF data embedded.

  (Preview of this post removed the plus signs from each side of the LTRIM(...) )

  
  
  Once you understand the BITs, all the pieces come together

• eletuw

  SSCrazy

  Points: 2464

  More actions

  December 12, 2003 at 9:56 am

  #485986

  I think the problem in QA is setting the option to have column aligned in the result tab.

  Thanks for your response.