nvl /min function question

I have been trying to run a PL/SQL program where I am looking for a minimum value of a column in a table which is greater than a certain other value. In some cases I get a null value, so I would like to use nvl to change the null values to the same constant. So, my question, is it possible to "wrap" the nvl function around the min function. I have tried to use something like select nvl(min(A),99999) into v_A from TABLE where A > B;

but that doesn't work. What should I do instead?

TIA Received on Tue Jun 23 1998 - 09:22:46 CDT