Replace character in SQL

SELECT REPLACE(FieldName, SUBSTRING(FieldName, PStart, LEN(FieldName)-PEnd),'') AS NewFieldValues
FROM (
    SELECT FieldName, PATINDEX('%(City:%',FieldName) AS PStart, PATINDEX('%)%',FieldName) AS PEnd 
    FROM TableName
    WHERE PATINDEX('%(City:%',FieldName)>0
) AS T

DECLARE @tmp TABLE (SomeString VARCHAR(255))

INSERT INTO @tmp (SomeString)
VALUES('Address : Nehru Road Ext., Vile Parle (East)
Near Domestic Airport, Mumbai – 400099.
Maharashtra. INDIA. ( City :- Mumbai )
Tel : Not Available'),
('Address : Bahru Road Ext., Vile Parle (West)
Near Domestic Airport, Calcuta – 422099.
Maharashtra. INDIA. ( City :- Calcuta )
Tel : UN')

SELECT REPLACE(SomeString, SUBSTRING(SomeString, PStart, PEnd-1-Pstart),'') AS NewFieldValues
FROM (
    SELECT SomeString, PATINDEX('%( City%',SomeString) AS PStart, PATINDEX('%Tel%',SomeString) AS PEnd 
    FROM @tmp
    WHERE PATINDEX('%( City%',SomeString)>0
) AS T

Address : Nehru Road Ext., Vile Parle (East)
Near Domestic Airport, Mumbai – 400099.
Maharashtra. INDIA. 
Tel : Not Available

Address : Bahru Road Ext., Vile Parle (West)
Near Domestic Airport, Calcuta – 422099.
Maharashtra. INDIA. 
Tel : UN