Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sql Query problem

sql Query problem

From: Eddie <q9522973_at_mail.connect.usq.edu.au>
Date: 1997/04/30
Message-ID: <3367C1AB.7C83@mail.connect.usq.edu.au>#1/1

OK I'm using sql*reportWriter and asking for help with the following problem.

The help i really need is with the query to which i have to generate the report with.
 i need to list all of a personnel table except Address and FaxNo

The field in the problem are there is
FamilyName, Title, GivenNames

the query has to return these fields in the following

Title GivenNames FamilyName
----- ---------- ---------
Mr Kim Gary Jones

what i need returned is

Mr K. Jones

I need only the first initial and there to be only 1 space between the MR the K. and Jones

i can work out the spacing part but how do i get only the first characther in Given Names to be returned ... please help ... mail reply's to me aswell asposting to the news group if possible.

-- 
---
-----------------------------------------------------
Eddie - q9522973_at_mail.connect.usq.edu.au
The University of Southern Queensland
The opinion expressed is that of the writer, 
and not necessarily that of the University.
Received on Wed Apr 30 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US