-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of George WeaverSent: Wednesday, November 12, 2003 8:15
PMTo: Josh Berkus; [EMAIL PROTECTED]; Louise
CofieldSubject: Re: [SQL] Looks are important
Hi Louise, Josh,
Thanks for the suggestions.
What I'm trying t
TECTED]>; "Louise
Cofield" <[EMAIL PROTECTED]>
Sent: Wednesday, November 12, 2003 9:31 PM
Subject: Re: [SQL] Looks are important
> "George Weaver" <[EMAIL PROTECTED]> writes:
> > ... the ' 's are not quite the same width as=
> > an ordinary
"George Weaver" <[EMAIL PROTECTED]> writes:
> ... the ' 's are not quite the same width as=
> an ordinary number or letter. Thus the physical display length of "30 cha=
> racters" (padded) can vary from row to row. The result is that the kinds do=
> n't necessary line up neatly. I need to concat
oncatenate 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 -
From:
Louise
Cofield
To: 'George Weaver' ; [EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 5:19
P
Wednesday, November 12, 2003 3:12
PMTo: [EMAIL PROTECTED]Subject: [SQL] Looks are
important
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 g
George,
> SELECT RPAD(no,30,' ') || tableb.kind FROM tablea
> WHERE tablea.kind = tableb.kind
Try SELECT RPAD(no, (35 - LENGTH(tableb.kind)), ' ')
--
-Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 7: don't fo
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
Green5966
Yellow106-60033
