Generate random unique number through a webservice !

[swethabilla]

Hi all,

I am trying to auto generate a random 8-digit number to be populated
in a SQL server 2005 table . I am using a webservice to do so.This
autonumber will be further used in the infopath form( as queried
data).

The webservice needs to generate an random number for which I have
used in the Random() function. However I need to check back with the
previously filled entries to see if the random number produced does
not match the previous entries(need to be unique).

I can't find a way to write this query in the webservice.

Can anyone pls suggest me on this query?

Thanks in advance.
Swetha.