Thank you for taking a look, This is the code I have been trying.

UPDATE TA

SET ServerName= REPLACE(ServerName, '%.%.dim.com', '')

WHERE Servername like '%.%.dim.com%'

basically I want to remove anything that starts with...