Re: sql column headings on result screens

> Select vnvend as Vendor....
sounds simple. I tried multi word column headings like
SELECT SPRECD as RC, SPPART as PART,SPDEPT as "IV  DEPT",
and it required double quotes (single quotes failed).
Column  Headings were then  RC     PART    "IV  DEPT"
Am I missing something that would allow no double quotes on heading?
jim

----- Original Message ----- 
From: "Steve Landess" <sjl_123@xxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Cc: "Jim Franz" <franz400@xxxxxxxxxxxx>
Sent: Monday, February 16, 2004 11:16 AM
Subject: Re: sql column headings on result screens


> > Jim wrote:
> > Users are complaining about our "fully descriptive" column headings
> > on sql searches. In a simple select statement
> > Select vnvend, vnname, vnstatus from vendor where vnname like '%SMITH%'
> > is there a way to change the column headings for "some" of the selected
> fields?
>
> Jim, how about:
>
> Select vnvend as Vendor, vnname as Name, vnstatus as Status from vendor
> where vnname like '%SMITH%'
>
> The "as" clause allows you to specify a name to use as the heading for the
> query instead of the Column Heading information from the file field
> description.
>
> Steve
>
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>