STRING_SPLIT()

The STRING_SPLIT() function is a table-valued function that splits a string into a table that consists of rows of substrings based on a specified separator. Syntax is STRING_SPLIT ( string , separator [ , enable_ordinal ] )

select value from string_split('hakan','a')

Output:
h 
k 
n