I want to retrieve the max value of a column or return 0 if it is NULL. I know how to write it in SQL 92 -
SELECT
CASE
WHEN max(loc_csreq_id) IS NULL THEN 0
ELSE max(loc_csreq_id)
END
FROM csreq
Anyone have a quick translation to Access for me?
Thanks!!
SELECT
CASE
WHEN max(loc_csreq_id) IS NULL THEN 0
ELSE max(loc_csreq_id)
END
FROM csreq
Anyone have a quick translation to Access for me?
Thanks!!