thanks brian.

Andrew

http://eshopsoho.com

I went ahead and changed that. Seems to yield the same results. Problem is I think is that I have a clustered index on a different column for other main...

I agree Steve! I work for a web hosting Company and this comes up from time to time. Clients are looking for differences. I should no them but was just...

Anbu,

Thanks, I figured this one out using cold fusion and RANDRANGE.

Thanks,

Andrew

Anbu,

AWESOME!!! THAT Works great. I see you can use max(cost) as well. Are there other arguments?

Also, what does the 'x' before group mean?

Thanks Again,

Andrew