ASCII

1
SELECT
2
  char_val,
3
  ASCII(char_val) as ascii_code
4
FROM (
5
  SELECT 'A' as char_val UNION ALL
6
  SELECT 'a' UNION ALL
7
  SELECT 'Z' UNION ALL
8
  SELECT '0' UNION ALL
9
  SELECT '@'
10
);

1
SELECT
2
  name,
3
  LEFT(name, 1) as first_char,
4
  CASE
5
    WHEN ASCII(UPPER(LEFT(name, 1))) BETWEEN 65 AND 90 THEN 'Letter'
6
    WHEN ASCII(LEFT(name, 1)) BETWEEN 48 AND 57 THEN 'Number'
7
    ELSE 'Other'
8
  END as char_type
9
FROM products;

1
SELECT name
2
FROM items
3
ORDER BY
4
  CASE WHEN ASCII(name) BETWEEN 48 AND 57 THEN 1 ELSE 0 END,
5
  name;