To avoid this problem in any complicated stored procedures, initialize the variable to empty before using them in any string manipulation.

e.g.

Declare @MobileCode as varchar(50), @MobileCodeNew as varchar(50), @MobileCodeForN as varchar(50),...

Watching your breath also helps you relax quickly.

You are so right! Everyone sometimes or other hits this phase. When mind is tired and can't think of anything new or it cannot see what is the...