STRING_SPLIT in Azure Synapse Analytics

Question

Is STRING_SPLIT supported in Azure Synapse's T-SQL? If so, how to use it in a pre-existing SQL Pool?

I'm doing this

select STRING_SPLIT('one,two,three',',')

and getting this as a result

'STRING_SPLIT' is not a recognized built-in function name.

Answer 1

Yes, Anders, it is available:

select value from string_split ('one,two,three',',')

Documentation