Query to break and get the value in dropdownlist

I want a query from a column which will break the output and give the result which I want.

For Ex: If the Output of the column is

SAMARTH NAGAR¸LOKHANDWLA COMPLEX¸ANDHERI(W)

I want to only display Andheri(w) and If the output is single word say Andheri(W), it should not break it

I m using sql-server 2005

Here is some more details related to tablename and columnname

Select distinct Add2 from emp_mst