SQL query to get a value

Question

Hi I want to get the values A6 B5 from the values of a table column called (property). Whatever i need the values i get it after 4th _(underscore). Example of the values are as follows: yxmn_euheiu_uhfi_jdfhf_ A6 _hfurh dsfsdgdf_dsgrgrd_rshrfhfd_hsdsg_ B5 _Dgsdgd_asgsgsd Thanks allot Darma

Santhosh Kumar Jayaraman · 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 { if (str[i] == '_') { count++; if (count == 4) { Console.WriteLine(str.Substring(i+12)); } } } Console.ReadLine(); }

darma teja · Answer

Is there any c# code to get A6 B5 values

darma teja · Answer

Hi Santhosh Thanks for your reply. Actually that did not work. It is giving me error. Darma

Santhosh Kumar Jayaraman · Answer

this was already asked by you isnt? didnt it work? http://www.c-sharpcorner.com/Forums/Thread/190917/sql-query-to-get-value-after-four-_-symbols.aspx