sql×ֶδ¦ÀíÎÊÌâ

select A from B µÃµ½½á¹û ÉÌÆ·ÑÕÉ«:À¶É«|0000FF[100] ÏÖÔÚÏëÖ»Êǵõ½ À¶É«|0000FF Óï¾ä Ôõôд

---

select À¶É«|0000FF
from B
SQLÓï¾äÄѵÀ²»ÊÇÖ»ÏÔʾ²éѯµÄ×Ö¶ÎÂð

---

²éѯ³öÀ´ÔÙ×ö´¦Àí£¡

C# code:

//±¿·½·¨1
string str = "ÉÌÆ·ÑÕÉ«:À¶É«|0000FF[100]";
string[] csdn = str.Split('|');
csdn[0]=csdn[0].Substring(csdn[0].IndexOf(":")+1);
csdn[1]=csdn[1].Substring(0,6);
Console.WriteLine(csdn[0]+"|"+csdn[1]);


C# code:

//±¿·½·¨2:Ö»ÄÜÊdz¤¶È¹Ì¶¨µÄ
string str = "ÉÌÆ·ÑÕÉ«:À¶É«|0000FF[100]";
Console.WriteLine(str.Substring(5,9));

---

·¹ý£¬¿´¸ßÊÖ»ØÌû¡£

---

upÒ»ÏÂ2Â¥

---

up

---

ÒýÓÃ

SQL codeselectsubstring(A,charindex(':',A)+1,charindex('[',A)-charindex(':',A)-1)from B


SQL codedeclare@svarchar(40)set@s='ÉÌÆ·ÑÕÉ«:À¶É«|0000ff[100]'selectsubstring(@s,charindex(':',@s)+1,charindex('[',@s)-charindex(':',@s)-1)/*
                                       
---