From another ex lazyudbdba



SELECT ENAME,
CASE SUBSTR(ENAME,1,1) WHEN ',' THEN '1' END AS "POS",
CASE SUBSTR(ENAME,2,1) WHEN ',' THEN '2' END,
CASE SUBSTR(ENAME,3,1) WHEN ',' THEN '3' END,
CASE SUBSTR(ENAME,4,1) WHEN ',' THEN '4' END,
CASE SUBSTR(ENAME,5,1) WHEN ',' THEN '5' END,
CASE SUBSTR(ENAME,6,1) WHEN ',' THEN '6' END,
CASE SUBSTR(ENAME,7,1) WHEN ',' THEN '7' END,
CASE SUBSTR(ENAME,8,1) WHEN ',' THEN '8' END,
CASE SUBSTR(ENAME,9,1) WHEN ',' THEN '9' END,
CASE SUBSTR(ENAME,10,1) WHEN ',' THEN '10' END
FROM DEDBADM.EMP
WHERE ENAME LIKE '%,%'
ORDER BY ENAME
FETCH FIRST 100 ROWS ONLY;



DB2 & UDB email list listserv db2-l LazyDBA home page