-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
Title: Message
Try the TRIM function or
the LTRIM function:
SELECT RPAD(no,30,' ') || TRIM(tableb.kind) FROM tablea
WHERE tablea.kind = tableb.kind
Louise
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of George WeaverSent: Wednesday, Nov
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
