get a unique maximum field value

[nnmmss72]

i want to get the maximum of a integer field. how can i be sure that i will get the a unique maximum number. i mean if 2 users simultanously call the method , how can i be sure to get the unique maximum number

 

[jbenson001]

You can't. Is this being used for an ID column in a table as a unique key? If so, and you are using SQL Server, use an identity column for your key.