On this page

    Categories: String


    Splits a given string at a specified character and returns the requested part.


    SPLIT_PART(expression varchar, delimiter varchar, part_number int32) → varchar

    • expression: Input expression.
    • delimiter: String representing the delimiter to split the input expression by.
    • part_number: Requested part of the split. Must be an integer greater than zero.


    SPLIT_PART example
    SELECT SPLIT_PART('', '.', 1)
    -- 127