how to select 1000103 this string from M1011000103 .

Question

how to select 1000103 this string from M1011000103 . if hole value in the one column.. i want int x=1000103 and left M101

Rajeev Punhani · Answer

Hi Sanjay  Please check the below queries. select substring ( 'M1011000103'  0  5 ) select substring ( 'M1011000103'  5  7 ) If the above solution is helpful then accept the answer.

Suresh M · Answer

string str1 = M1011000103; string repStr = str1.Replace(M101); after that convert your string to int int value = Convert.ToInt32(repStr);

Chandu Kumawat · Answer

SELECT SUBSTRING ( 'Quadratically'  5 ); SSUBSTRING ( 'Quadratically'  5 ) ratically