On this page

    Categories: String, Binary

    ASCII

    Returns the ASCII code for the first character of a string. If the string is empty, 0 is returned.

    Syntax

    ASCII(expression varchar) → int32

    • expression: The string for which the ASCII code for the first character in the string is returned.

    Examples

    SELECT ASCII ('DREMIO')
    -- 68
    
    SELECT ASCII ('D')
    -- 68
    
    SELECT ASCII ('')
    -- 0