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

  • September 12, 2008 at 3:37 pm

    #871368

    Then why is it that regardless of session or db settings SQL90 returns "A A" for

    select 'A' + 'A'

    and

    select 'A ' + 'A'

    Is that because theres still a "table" involved albeit a temporary one and the "settings at creation" rule is being applied?