Difference between SQL Server 7 and 2000 to set ansi_padding.

[pctest]

Are there any difference between SQL Server 7 and SQL Server 2000 regarding set ansi_padding?

I have the following script:

set ansi_padding on
declare @x integer
select @x = 1
select case when @x = 1 then 'test ' else 'test2 ' end + 'result'

Running the script in SQL Server 2000 will get this:

test result

Running the script in SQL Server 7 will get this:

testresult

Why are the results be different?


Thank you for any help.