By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT TOP 100 CASE CAST(CRYPT_GEN_RANDOM(1)%2 AS BIT)
WHEN 0 THEN 'A'
WHEN 1 THEN 'B'
ELSE 'C'
END
FROM sys.all_objects
| (No column name) |
|---|
| A |
| A |
| C |
| B |
| C |
| A |
| A |
| C |
| A |
| A |
| A |
| B |
| A |
| C |
| A |
| A |
| C |
| C |
| B |
| C |
| A |
| C |
| A |
| A |
| C |
| C |
| C |
| B |
| A |
| B |
| A |
| B |
| A |
| C |
| B |
| B |
| B |
| C |
| A |
| B |
| A |
| A |
| A |
| A |
| C |
| A |
| A |
| C |
| B |
| A |
| C |
| C |
| A |
| A |
| A |
| A |
| C |
| B |
| A |
| C |
| C |
| B |
| A |
| A |
| C |
| B |
| C |
| A |
| A |
| C |
| A |
| A |
| A |
| A |
| C |
| A |
| B |
| C |
| C |
| A |
| A |
| B |
| C |
| B |
| B |
| B |
| B |
| C |
| B |
| A |
| A |
| B |
| A |
| A |
| A |
| C |
| C |
| A |
| B |
| C |