how to select 1000103 this string from M1011000103 .

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.

0

string str1 = "M1011000103";

string repStr = str1.Replace("M101","");

after that convert your string to int

int value = Convert.ToInt32(repStr);

0

SELECT SUBSTRING('Quadratically',5);

SSUBSTRING('Quadratically',5)
ratically

0