You can use the NewID() function ... object in Enterprise Manager or with the sp_rename stored procedure. Unfortunately, SQL Server then only modifies the object name in the sysobjects table.

With SQL Server ... function to have the fragment converted to a virtual table, effectively creating a table from a column in the row. You can then join that virtual table to its row using CROSS APPLY ...