David,

If that's the case,  I'll stick to your earlier post..

Thanks for your support.

-Dhodie

-----Original Message-----
From: David Cameron [mailto:dcameron@i...]
Sent: Monday, January 13, 2003 2:15 PM
To: sql language
Subject: [sql_language] RE: creating auto number on the fly

> Yes, if there's such a built in function . I am using MS SQL 7.0

There is nothing to do this. SQL Server 2000 supports the creation of User
defined functions (ie you write them), but even these do not work on an
entire resultset at once. AFAIK your only solution is the one I posted.

regards
David Cameron
nOw.b2b
dcameron@i...

---