-- define our data table<\/div>WITH data( num )<\/div>AS<\/div>(<\/div> -- our value range in a single query<\/div> SELECT 0 AS \'num\'<\/div> UNION<\/div> SELECT 512 AS \'num\'<\/div> UNION<\/div> SELECT 1024 AS \'num\'<\/div> UNION<\/div> SELECT 1536 AS \'num\'<\/div> UNION<\/div> SELECT 2048 AS \'num\'<\/div>)<\/div>SELECT TOP 1 num FROM data <\/div>ORDER BY NEWID()<\/div><\/pre><\/div>\n \n <\/div>\n\n