Re: SELECT with IF THEN ELSE

Thanks. Can't seem to get this to work:

SELECT SELECT_FROM_PART, SUM(QTY_DUE), CASE SUBSTR(REQUEST_ID,1,1) WHEN != 'I' THEN SUBSTR (REQUEST_ID,3,4) ELSE NULL END, NEED_DATE, REQUEST_ID
FROM REQ1
WHERE STATUS IN ('O','H')
AND (SELECT_FROM_SC LIKE '1ASL%' OR SELECT_FROM_SC = 'LASR') GROUP BY SELECT_FROM_PART, SUBSTR (REQUEST_ID,3,4), NEED_DATE, REQUEST_ID
ORDER BY SELECT_FROM_PART Doesn't like != 'I' ... why is that? Received on Mon Dec 20 2004 - 12:14:47 CST