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