Re: MAX NUMBER

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_at_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