[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: SQR puzzle o' the week
! Nick Moscaritolo
! Bentley College
! >>>>> for SQR 2.x - we do not have SQR 3 yet
BEGIN-REPORT
move '' to $new_str_var
move 1 to #char_ctr
DO get_column
show (15,1) cs $new_str_var
END-REPORT
BEGIN-PROCEDURE get_column
BEGIN-SELECT
'HOWDY' &str_var
WHILE #char_ctr <= length(&str_var)
let $new_str_var = $new_str_var||substr(&str_var,#char_ctr,1)||' '
add 1 to #char_ctr
END-WHILE
FROM system.dual
END-SELECT
END-PROCEDURE get_column