## Syntax
```mermaid
%%{init: {
'theme': 'base',
'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' },
'themeVariables': {
'fontSize': '11px',
'fontFamily': 'Arial'
}
}}%%
flowchart TD
stringSplitSpec_start((START))
stringSplitSpec_start --> stringSplitSpec_0_0["STRING_SPLIT("]:::quoted
stringSplitSpec_0_0 --> stringSplitSpec_0_2[<a href="Invantive UniversalSQL/Grammar/Expression" class="internal-link">expression</a>]
stringSplitSpec_0_2 --> stringSplitSpec_0_3[","]:::quoted
stringSplitSpec_0_3 --> stringSplitSpec_0_4[<a href="Invantive UniversalSQL/Grammar/Expression" class="internal-link">expression</a>]
stringSplitSpec_0_4 --> stringSplitSpec_0_5[")"]:::quoted
stringSplitSpec_0_5 --> stringSplitSpec_end((END))
```
## Purpose
Splits a text upon another text, return one row per element.
Parameters:
- Input: The text to split.
- Splitter: Text being split upon.
Returns: a number of rows with one column named 'value'; one per element in the input.
```sql
select spn.code
, spn.data_container_alias
from systempartitions@DataDictionary spn
join string_split('868035,868041', ',') spl
on spl.value = spn.code
```