Re: Newbie Question: Modify Select Output

From: Doug O'Leary <dkoleary_at_mediaone.net>
Date: Mon, 28 Feb 2000 19:17:09 -0600
Message-ID: <MPG.1324da0f17a0d2e1989741@nntp.ce.mediaone.net>

In article <89e90r$55l$1_at_weber.a2000.nl>, johan_park_at_hotmail.com says...
> Is it possible to modify the select output.
> I would like to get something like:
>
> Number: 1
> Name: John
> Lastname: Johnson
> Place: Texas
>

Hey;

---

set heading off

select 'Number: '||num||'

Name:     '||name||'
Lastname: '|| lname || '
Place:    '|| place

from <table>;

set heading on

---

There should be a way using escaped newline characters, but the above works...

Doug

--

---

Douglas K. O'Leary
Senior System Admin
dkoleary_at_mediaone.net

---

Received on Mon Feb 28 2000 - 19:17:09 CST