At 11:57 AM 15/08/2004 +0000, you wrote:

>Hi Helen
>
>Thanks for the reply and suggestion, the way I was searching through
>the table was silly anyway, why I di it that way I will never know.
>
>Below is the code I used.

This is wrong:
//SELECT 1 id FROM PRODUCT
// WHERE (STOCK_ON_HAND < LOW_WATERMARK)

To return a "result" it should be
SELECT 1 FROM PRODUCT
WHERE (STOCK_ON_HAND < LOW_WATERMARK)

or to return a list of ids where the stocklevel is too low:

SELECT id FROM PRODUCT
WHERE (STOCK_ON_HAND < LOW_WATERMARK)

Helen