Try this:

/* Schema fix all tables.sql

By: MJW 02/05/2010

Desc: change all tables from one schema to another

*/

declare @sql varchar(8000), @table varchar(1000), @oldschema varchar(1000), @newschema varchar(1000)

set @oldschema = 'dbo'

set @newschema = 'Training'

while...

Not sure what you mean by 'within the cell in the result row' but you can use the char() function to insert formatting codes into any string.

New code:

BEGIN

DECLARE @Return VARCHAR(8000)

SELECT...