>

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
>

VFP

lcStr = "DEMO"
FOR i=1 TO LEN(lcStr)
	? SUBSTR(lcStr, i,1)
ENDFOR

>> 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