Yeah ,

of course Luis Cazares , surely I will do here after .

Thank u very much Luis Cazares for your valuable time. your code is working awesome.

as per your suggestion I refer 'http://dwaincsql.com/2014/03/27/tally-tables-in-t-sql/' site also. its very useful to me ....

Thank u very much Eirikur Eiriksson . your code is working perfectly. really its awesome.

could u please suggest me .. in your free time ....,

what is the mistake...

Hi ,

your mobile number count is just 9 degits. that's why their is no change.

declare @phone VARCHAR(15) = '842507889'

BEGIN

DECLARE @Formatted VARCHAR(15)

IF (LEN(@phone) > 10)

SET @Formatted = '0' + SUBSTRING(@phone,3,9)

ELSE...