Skip to main content

dbo.fnParseIntList

Description

Parses a comma-separated string of integers into a table of int values.

Syntax

dbo.fnParseIntList(@input)

Parameters:
  • @input (varchar(max)): Comma-separated list of integers

    • Returns:
    Returns a table with columns:
  • Value (int): Parsed integer value

    • Code Example​

    -- Split a comma-separated string into integer rows
    SELECT *
    FROM dbo.fnParseIntList('1,2,3,4,5');