LTRIM/RTRIM NOT TRIMMING

  • 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.

  • 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

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

    Thanks for your response.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply