//01|02|03| ====> (01,02,03)
string s = "(";
for (int i = 0; i < countryid.Split('|').Length; i++)
{
if (i > 0 && i < countryid.Split('|').Length-1)
{
s += ",";
}
s +=countryid.Split('|')[i];
}
s += ")";
string.Format(" CountryID in {0} ", s)