Hi,

I have requirement of randomly select between two different criteria to filter my data. This randomness will be implemented by inspecting the value of the current time, if the final digit of that value is even, then products beginning with T that are in stock will be displayed; if the digit is odd, then the application will display products beginning with E that have a unit price greater than $5.00. What should I need to do to achieve this goal?

Please help. 

I'm not so sure about your requirement but you can check out the link below :

http://dotnetguts.blogspot.com/2007/08/sql-server-faq-on-random-category.html 

This might be helpful for you.