Looks wrong, if you go more than 1 above the maximum char number then it will loop through again.

if you change the WHILE statement from while (@counter < @Occurrence)...