At 07:38 AM 2/01/2005 +0000, you wrote:

>Thanks Helen. I followed your advice and successfully setup the floor
>udf. However, its still not usuable in the stored procedure.

When do see an exception and what is the exception?

>Do I need
>to declare it within the procedure somehow?

No, only to the database. But maybe you are having difficulties because
you tried to compile the procedure before the function declaration was
committed?

> I will gladly post the procedure if that is required.

Do, if you think it will help.

./heLen