SQL Server 2016 invalid object name STRING_SPLIT

Question

In SQL Server 2016, I get this error with the STRING_SPLIT function

SELECT * FROM STRING_SPLIT('a,b,c',',')

Error:

Invalid object name STRING_SPLIT.

Answer 1

Verify Database Compatibility Level 130

you can use the following query to change it:

ALTER DATABASE [DatabaseName] SET COMPATIBILITY_LEVEL = 130

Answer 2

I used Split_stringthat in grammar correct in English, but my old eyes did not see what it should be STRING_SPLIT... so if you are a little mental STRING_SPLITlike me, then check that you typed the command correctly! :)