STRING_SPLIT error tsql

Question

I'm following the docs but thrown error.

There is incorrect near ,

SELECT ProductId, Name, value  
FROM Product  
    CROSS APPLY STRING_SPLIT(Tags, ',');

I'm using the sample said in the documentation, but why?

https://learn.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-ver16

Answer 1

Hi @Jefferson,

Please first check your SQL Server version.

The function applies to SQL Server 2016 (13.x) and later.

In addition, STRING_SPLIT requires the compatibility level to be at least 130. When the level is less than 130, SQL Server is unable to find the STRING_SPLIT function.

You may have a double check.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.