I have a SQL query that is being used to create a radiogroup/list of values.
The query looks something like this:
select value 1 || ' ' || currency value d, value 2 r
from table
Results from query:
Milk $1.00
Toast $3.00
Pie $0.50
Bread $10.00
I am trying to get the currency values to line up nicely with each other, but I am unable to do so. I have tried using rpad and lpad.
Results I would like to see:
Milk $1.00
Toast $3.00
Pie $0.50
Bread $10.00
OR
Milk $1.00
Toast $3.00
Pie $0.50
Bread $10.00
I was just wondering if anyone else has done something similar, and got it to work.