Reiro wrote:
> im using oracle 9i and my query for increase the id is
> nz(max(asset_id),0) + 1 its incorpated into my insert statement.
>

What is the NZ function? Any reason why you can't code a trigger to do
this for you on INSERT? Any reason why you can't use a sequence to
determine the number?

Cheers,
Brian

--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown