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
Reginald J Ray Jr
Old Hand
Points: 383
More actions
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