Suppress the 0 value

[Martin Rytz]

Hi MySQL-Users
 
I have a simple select statement like 'select id from table'. The result is
0, becaues the id field is 0 (int-field).
 
My problem is now how to suppress the 0 and give NULL instead of 0 as the
result (i.E. everytime the result from the select is 0 it should be NULL).
 
How can this be done within the select-statement?
 
Thank you in advance,
Martin Rytz