By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT
SV.number,
CHAR(SV.number)
FROM master.dbo.spt_values AS SV
WHERE
SV.[type] = 'P'
AND SV.number BETWEEN 1 AND 255
AND CHAR(SV.number) COLLATE SQL_Latin1_General_CP1_CS_AS LIKE '[A-Z]'
ORDER BY
CHAR(SV.number) COLLATE SQL_Latin1_General_CP1_CS_AS ASC;
| number | (No column name) |
|---|---|
| 65 | A |
| 97 | a |
| 192 | À |
| 224 | à |
| 193 | Á |
| 225 | á |
| 194 | Â |
| 226 | â |
| 195 | Ã |
| 227 | ã |
| 196 | Ä |
| 228 | ä |
| 197 | Å |
| 229 | å |
| 198 | Æ |
| 230 | æ |
| 66 | B |
| 98 | b |
| 67 | C |
| 99 | c |
| 199 | Ç |
| 231 | ç |
| 68 | D |
| 100 | d |
| 69 | E |
| 101 | e |
| 200 | È |
| 232 | è |
| 201 | É |
| 233 | é |
| 202 | Ê |
| 234 | ê |
| 203 | Ë |
| 235 | ë |
| 70 | F |
| 102 | f |
| 71 | G |
| 103 | g |
| 72 | H |
| 104 | h |
| 73 | I |
| 105 | i |
| 204 | Ì |
| 236 | ì |
| 205 | Í |
| 237 | í |
| 206 | Î |
| 238 | î |
| 207 | Ï |
| 239 | ï |
| 74 | J |
| 106 | j |
| 75 | K |
| 107 | k |
| 76 | L |
| 108 | l |
| 77 | M |
| 109 | m |
| 78 | N |
| 110 | n |
| 209 | Ñ |
| 241 | ñ |
| 79 | O |
| 111 | o |
| 210 | Ò |
| 242 | ò |
| 211 | Ó |
| 243 | ó |
| 212 | Ô |
| 244 | ô |
| 213 | Õ |
| 245 | õ |
| 214 | Ö |
| 246 | ö |
| 216 | Ø |
| 248 | ø |
| 80 | P |
| 112 | p |
| 81 | Q |
| 113 | q |
| 82 | R |
| 114 | r |
| 83 | S |
| 115 | s |
| 223 | ß |
| 84 | T |
| 116 | t |
| 85 | U |
| 117 | u |
| 217 | Ù |
| 249 | ù |
| 218 | Ú |
| 250 | ú |
| 219 | Û |
| 251 | û |
| 220 | Ü |
| 252 | ü |
| 86 | V |
| 118 | v |
| 87 | W |
| 119 | w |
| 88 | X |
| 120 | x |
| 89 | Y |
| 121 | y |
| 221 | Ý |
| 253 | ý |
| 255 | ÿ |
| 90 | Z |