/*code to find primes courtesy of J Celko in this discussion:http://social.msdn.microsoft.com/Forums/sqlserver/en-US/90a58cc7-dada-476a-8d27-f744c71940e6/how-to-find-whether-is-a-prime-or-non-prime-with-one-select-statement?forum=transactsql*/

______________________________________________________________you can lead a user to data....but you cannot make them think and remember....every day is a school day