SELECT CAST(NEWID() AS CHAR(36)), CASE CAST( ASCII (SUBSTRING( CAST( NEWID() AS VARCHAR(64)), 1, 1)) AS INT) % 2 WHEN 0 THEN 'OPTION 1' ELSE 'OPTION 2' END, CASE ABS(CHECKSUM(NEWID()) % 2) WHEN 0 THEN 'OPTION 1' ELSE 'OPTION 2' ENDFROM (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12)) r (n)