AW: SQL Problem

["Michael Plonka" <plonka@xxxxxx>]

select case when v01art = 1 then 'a'
            when v01art = 2 then 'b'
            when v01art = 3 then 'c'
       end case
from tablename


-----Ursprüngliche Nachricht-----
Von: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]Im
Auftrag von Albino Sousa
Gesendet: Freitag, 14. Dezember 2001 12:39
An: 'RPG400-L@midrange.com'
Betreff: SQL Problem



Is there a way to convert in SQL, a code from a table in something more
significant?
Select field1, field2, field3 (this one is the code field) but list X, L, M
etc. and i want X appears as EXTRA, M = MEDIUM and L as LARGE.
Thanks


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.