Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jack Corbett ANSI PADDING, Trailing Whitespace, and Variable Length Character Colum RE: ANSI PADDING, Trailing Whitespace, and Variable Length Character Colum

  • August 3, 2009 at 2:59 am

    #1033557

    It's not quite that bad... with ANSI PADDING ON, VARCHAR can have trailing spaces if they've been assigned. It won't automatically pad spaces to the total width of the column. I can live with that... I just worry about others that can't. It would be like them setting ANSI NULLS to OFF permanently... that would absolutely kill a lot of my code where I depend on NULL being treated for what it is... unknown.

    I suspect there's not much we can do.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)