SQL query to get a value

Accepted answer

You meant to say the Sql code which i gave its not working?Its working for me.

If you want same thing in c# code,

static void Main(string[] args)

{

string str = "yxmn_euheiu_uhfi_jdfhf_A6_hfurh";

int count=0;

for (int i = 0; i < str.Length; i++)

{

if (str[i] == '_')

{

count++;

if (count == 4)

{

Console.WriteLine(str.Substring(i+1,2));

}

Console.ReadLine();

}

Is there any c# code to get A6, B5 values

Hi Santhosh,

Thanks for your reply.

Actually that did not work.

It is giving me error.

Darma