SQL · String functions

ascii()

The code of the first character. SQLite uses unicode().

Syntax
ascii(text)

Example

Open in the lab

More in this group

char_length() chr() concat_ws() format() initcap() instr() with start left() / right() like with escape

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course