CREATE TABLE addrname(addnam varchar(50))

insert into addrname

values('roshan,hrithik(india)')

go

create table separated(firstname varchar(50),lastname varchar(50),address varchar(50))

go

insert into separated

select

SUBSTRING(addnam,PATINDEX('%,%',addnam)+1,PATINDEX('(%',addnam)-1-PATINDEX('%,%',addnam))as firstname,

SUBSTRING(addnam,0,PATINDEX('%,%',addnam))as lastname,

SUBSTRING(addnam,PATINDEX('%(%',addnam)+1,PATINDEX('%)%',addnam)-1-PATINDEX('%(%',addnam))as address

from addrname

it looks messy check if it works for you