Re: [SQL] Looks are important

[Louise Cofield]

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 Weaver Sent: Wednesday, November 12, 2003 3:12 PM To: [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 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