If you are using SQL Server 2016 version and still you are getting the error Invalid object name ‘STRING_SPLIT’ as shown below while using the functions which are newly introduced (with the same version) –
that means the database compatibility is set to the level in which SQL Server is unable to find the functions. When we migrate/restore the databases to a newer version and try to use the newly introduced functions without changing the database compatibility level such errors will occur.
In this case, we are going to change the compatibility level from 120 to 130 so as to String_Split function works.
Follow the below steps:
1) Go to Object explorer
2) Right-click on the database,
3) Go to Options
4) Change the Compatibility Level from SQL Server 2014 (120) to SQL Server 2016 (130)
5) Click OK and execute the query again.