SQL is not so good at string manipulation ,but has its basic string functions to use -
http://msdn.microsoft.com/en-us/library/ms181984.aspx[
^]
For you this may help:
DECLARE @VALUE AS NVARCHAR(MAX)
DECLARE @POS AS INT
SET @VALUE = 'UP.SD.CP.COM'
SET @POS = CHARINDEX('.', REVERSE(@VALUE), CHARINDEX('.', REVERSE(@VALUE)) + 1) - 1
SELECT RIGHT(@VALUE, @POS)