DECLARE @Test varchar(max) SET @Test = '' SELECT @Test = @Test +'ALTER TABLE '+Object_Name(Object_Id)+' ALTER COLUMN '+NAME+' Uniqueidentifiier'+CHAR(13)+CHAR(10) FROM sys.columns WHERE system_type_id = 175 AND max_length = 36 AND Object_Name(Object_Id) NOT LIKE 'sys%' print @test(Slaps head) - I had forgotten you could concatenate inline. Boris wins the refactoring award! Thanks.