How can I split a string into different parts in sql.

 
DECLARE @frastr [nvarchar](128), @dmyndlstr[nvarchar](128), @nfrnchsint [int], @dracint [int]
SET @frastr = '123Test$%^'
SET @dmyndlstr = ''
SET @nfrnchsint = LEN(@frastr)
SET @dracint = 0
 
WHILE @dracint < @nfrnchsint + 1
    BEGIN
       SET @dmyndlstr = SUBSTRING(@frastr,0,@nfrnchsint + 1)
		PRINT @dmyndlstr
		SET @nfrnchsint = @nfrnchsint -1
	END

DECLARE @frastr [nvarchar](128), @dmyndlstr[nvarchar](128), @nfrnchsint [int], @dracint [int]
SET @frastr = '123Test$%^'
SET @dmyndlstr = ''
SET @nfrnchsint = LEN(@frastr)
SET @dracint = 0
 
WHILE @dracint < @nfrnchsint + 2
    BEGIN
       SET @dmyndlstr = SUBSTRING(@frastr,0,LEN(@frastr)-@nfrnchsint)
		PRINT @dmyndlstr
		SET @nfrnchsint = @nfrnchsint -1
	END	

DECLARE @frastr [nvarchar](128), @dmyndlstr[nvarchar](128), @nfrnchsint [int], @dracint [int]
SET @frastr = '123Test$%^'
SET @dmyndlstr = ''
SET @nfrnchsint = LEN(@frastr)
SET @dracint = 0
 
WHILE @dracint < @nfrnchsint
    BEGIN
       SET @dmyndlstr = LEFT(@frastr,1)
		PRINT @dmyndlstr
		SET @frastr = RIGHT(@frastr,@nfrnchsint-1)
		SET @nfrnchsint = @nfrnchsint -1
	END