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