This is the code we have been using to do this, it's almost certainly not the best way of doing it but it works

DECLARE @index int,@Char CHAR(1),@InputString VARCHAR(255),...