Title: Message
|
Using
a fixed-width font as Tom suggests, concatenate an additional space between the
no field and the kind field:
SELECT RPAD(no,30,' ') || ' '
|| TRIM(tableb.kind) FROM tablea
WHERE tablea.kind = tableb.kind
Louise
Hi Louise, Josh,
Thanks for the suggestions.
What I'm trying to accomplish is to have a space
between no and kind. Length(no) can vary. I would like all the
kinds to line up evenly when displayed, with a space between no and
kind. But when I RPAD no (to try and get an even starting point for
kind), the ' 's are not quite the same width as an ordinary number
or letter. Thus the physical display length of "30 characters" (padded)
can vary from row to row. The result is that the kinds don't necessary line up
neatly. I need to concatenate the two as they are being displayed as one
column in a drop down combobox.
Is what I'm trying to do possible???
George
----- Original Message -----
Sent: Wednesday, November 12, 2003 5:19
PM
Subject: RE: [SQL] Looks are
important
Try the TRIM function
or the LTRIM function:
SELECT RPAD(no,30,' ') || TRIM(tableb.kind) FROM tablea
WHERE tablea.kind = tableb.kind
Louise
Hi Everyone,
I am trying to concatenate two fields through
a query:
SELECT
RPAD(no,30,' ') || tableb.kind FROM tablea
WHERE tablea.kind =
tableb.kind
The result gives (for
example):
4595448
Green
5966
Yellow
106-60033
Green
15-94-387
Red
217-991173
Blue
What I would like to have is
better alignment:
4595448 Green
5966
Yellow
106-60033 Green
15-94-387 Red
217-991173 Blue
Is there some kind of encoding or other
string options that will result in better alignment than what I've tried
with Rpad?
Thanks in advance,
George
|
