How to slipt the values in SQL server

[phanimadhav]

Hello this is sudheer.I am learning SQLSERVER .My Table is


Org_Countryname:
india;Australia;pakistan;England;SouthAfrica;
india;Australia;pakistan;England;SouthAfrica;.Newz land;
india;Australia;pakistan;England;SouthAfrica;.Newz land;srilanka;


My table name is organisation
in my table contain below column names

Org_name, Org_Countryname,Org_Activity,Org_Secu_Id.Org_ID

my problem is if i want display first 2 countynames in Org_Countryname
means my org_Activity='Activity' then we want display the only two county names india,Australia;

if u know the answer please send the query urgently thanks for ur advanced replay

[azimmer]

Hello this is sudheer.I am learning SQLSERVER .My Table is


Org_Countryname:
india;Australia;pakistan;England;SouthAfrica;
india;Australia;pakistan;England;SouthAfrica;.Newz land;
india;Australia;pakistan;England;SouthAfrica;.Newz land;srilanka;


My table name is organisation
in my table contain below column names

Org_name, Org_Countryname,Org_Activity,Org_Secu_Id.Org_ID

my problem is if i want display first 2 countynames in Org_Countryname
means my org_Activity='Activity' then we want display the only two county names india,Australia;

if u know the answer please send the query urgently thanks for ur advanced replay

Here goes a wordy pattern:

declare @countries as varchar(255)
declare @cutoff as integer
set @countries='india;Australia;pakistan;England;SouthAfrica;.Newzland;'
set @cutoff=case when charindex(';',@countries)>0 then charindex(';',@countries) else len(@countries) end
set @cutoff=case when charindex(';',@countries,@cutoff+1)>0 then charindex(';',@countries,@cutoff+1) else len(@countries) end
select left(@countries,@cutoff) as firsttwo
 

It's more understandable this way but once you see how it works it is possible to merge the lines so that you can put it right into a SELECT.