Hi,

The statement

SELECT @MyString = 'foo'

is populating the variable with the value 'foo' to return this value you would then need to select the variable

SELECT @mystring

BOL reference: http://msdn.microsoft.com/en-us/library/ms187953(v=SQL.105).aspx