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 8:09 am

    #870988

    I'm confused. I get the same results from 'select * from duh' for both settings of ANSI_PADDING.

    set ANSI_PADDING off

    go

    create table duh (

    col1 varchar(50)

    )

    insert into duh select 'a ' + 'a'

    select * from duh

    drop table duh

    jack ray

    jray@validata.org