| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> sql Query problem
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
![]() |
![]() |