Hey Grauy,
Try this:
select top 1 lettercode, rand()*1000000 as randomno from mytable order by randomno/Pierre Unge, Sweden
>Our company is creating a sweepstakes application that will randomly select a winner each month. We are having difficulty putting code together that will help us select a winner. We are using one table that has two fields in it. A three letter code (AFS) field and a dateime field. Does anyone have any simple code that might be helpful in selecting a winner or have any ideas on how to generate a winner.
>
>Thanks in advance
------------- if you cut here, you'll probably destroy your monitor ------------