Re: Help on Query!

Scott wrote:
> I have a table A, that has columns,
>
> ColA
> ColB
> ColC
>
> The value is ColC is stored as 'IN' and 'OUT'.
>
> How do I write a query that selects 'IN' or 'OUT' and if it is 'IN', it
> should
> get displayed as 'Input Parameter' and if 'OUT' it should get displayed
> as
> 'Output Parameter'.
>
> Thanks in advance.

You ask your instructor for extra help after class.

For all other c.d.o.s. denizens ... I gave my students their midterm tonight. It is ... of course ... purely a coincidence ... that these requests for queries against tables named emp and A all showed up now.

Please do not give away the answers. Thanks.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)