Hi

I have a problem with datagrid1.
Downloading data through Adodc1 but I can not add another column in which if in column1 I have 01 in the added column gives me 100 if 02 is 200, 03 is 500, 04 is 70
The query from the database I have such
Code:
select SUBSTR (number, 1,2),
 SUM (ILOSC) FROM my data WHERE status = '200' AND city = 'Wroclaw' 
GROUP BY SUBSTR (number, 1,2), ILOSC ORDER BY SUBSTR ( number, 1,2) ASC