• 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