>One more question, where would I put NOCONSOLE in this statement? I have tried different spots of this SQL and some gives error message (odd) or still run with showing the results (want to hide the results and go ahead to the next line of REPORT FORM...)
>
>Chuck

select * from (lcAlias) ;
			where &lcfield == lcvalue to screen noconsole