Home Forums Data Warehousing Data Transformation Services (DTS) How does RTRIM work in this query mentioned below RE: How does RTRIM work in this query mentioned below

  • January 29, 2009 at 7:26 am

    #934661

    Thanks guys for you answers.I appreciate that

    , but my question remains unanswered.

    The job of RTRIM is to trim spaces.

    so how does it matter whether we use CHAR or VARCHAR because finally there wont be any spaces.