Show all Hide all

This function can be used to retrieve a table of integers parsed from a comma-separated string. Any element in the string that is not an integer will be ignored. Leading and trailing spaces are trimmed from numbers.

The recommended usage is to save the results into a temp-table before using them for performance reasons.

Type: Table-valued function
Area of use: General use


@string mandatory varchar(max)
A string of comma-separated integers.