get 2nd and 3rd string by splitting a long string using T-Sql

declare @fld varchar(50);
declare @str1 varchar(50);
declare @x int;
declare @str2 varchar(50);
declare @str3 varchar(50);
declare @tempstr varchar(50);
Select @fld = Field1 from table1;
Set @x=PATINDEX('%;;%',@fld);
Set @str1=SUBSTRING(Field1,0,@x);
Set @tempstr=substring(@fld,@x+2,999);
Set @x=PATINDEX('%;;%',@tempstr);
Set @str2=SUBSTRING(@tempstr,0,@x);
Set @str3=substring(@tempstr,@x+2,999);
select @str1 as location, @str2 as cntry1, @str3 as cntry2

DECLARE @S varchar(max),
  @Split char(1),
  @X xml
SELECT @S = 'USA;Japan;India',
@Split = ';'
SELECT @X = CONVERT(xml,'<root><s>' + REPLACE(@S,@Split,'</s><s>') + '</s></root>')
SELECT [Value] = T.c.value('.','varchar(20)')
FROM @X.nodes('/root/s') T(c)

DECLARE @string VARCHAR(30)

SET @string= 'USA;;Japan;;India'


;WITH Splitter AS
(
    SELECT LEFT(@string, CHARINDEX(';;',@string)-1) AS MyWord, RIGHT(@string, LEN(@string) - CHARINDEX(';;',@string)-1) AS Remainder
    WHERE CHARINDEX(';;',@string)>0
    UNION ALL
    SELECT LEFT(Remainder, CHARINDEX(';;',Remainder)-1) AS MyWord, RIGHT(Remainder, LEN(Remainder)-CHARINDEX(';;',Remainder)-1) AS Remainder
    FROM Splitter
    WHERE CHARINDEX(';;',Remainder)>0
    UNION ALL
    SELECT Remainder AS MyWord, NULL AS Remainder
    FROM Splitter
    WHERE CHARINDEX(';;',Remainder)=0
)
SELECT *
FROM Splitter

USA     Japan;;India
Japan   India
India   NULL