DECLARE @str varchar(16), @i int
SET @str = 'DEMO'
SET @i = 1
WHILE (@i <= DATALENGTH(@str))  BEGIN
	PRINT SUBSTRING(@str, @i,1)
	SET @i = @i + 1
END

> do we any split function ? let say split('DEMO') then it will return
> Row1 D
> Row2 E
> Row3 M
> Row4 O
>
> It tried it on PERL using Pattern Matching. Do we any equivalent in SQL or Foxpro? or any script that do.
> thank in advance