At 11:02 PM 6/03/2005 +0000, you wrote:

>Hi Helen
>
>Thanks for your help as always, but I am still a little confused.
>
>In your reply you added a For loop. The procedure I attempted to
>compile is as posted below. When I attempt to compile this I recieve a
>character unknown error ; on line 28 (the end of the into line).

Just remove the semi-colon! It's a statement terminator. The FOR SELECT
statement doesn't have one.

The pattern is this:

for select <specs>
into <vars>
do
begin
<nested statements>
end

./heLen