INSERT INTO [DBNAME].[dbo].[PART]
SELECT [ID] & '-RG' AS Expr1
So the key is adding the -RG to the end of the ID field from the otherdb which as the query stands gives me:
Msg 402, Level 16, State 1, Line 147
The data types varchar and varchar are incompatible in the '&' operator.