Thanks, but I have to agree with Erland

Steve
"Madhivanan" <madhivanan2001@gmail.com> wrote in message
news:1110279816.145987.160610@f14g2000cwb.googlegr oups.com...
>
> Steve,
>
> Select Max(IdentityField)+1 from TableName
>
> Madhivanan
>