Invalid object name 'STRING_SPLIT' in SQL Server 2019

Question

Hi Support,

Our SQL server version is 2019 and check the compatibility level is 150, but it still have error "Invalid object name 'STRING_SPLIT' ". We also tried the case sensitive according to this link, both of them have the same error.
https://social.msdn.microsoft.com/Forums/en-US/c2982f91-9fe0-4651-9462-168a8e34898f/why-stringsplit-is-invalid-while-stringsplit-is-fine?forum=sqltools

Any idea?

Thanks

Best Regards
Chong

Answer 1

Hi，@Chong

Welcome to Microsoft T-SQL Q&A Forum!
It looks more like a platform problem. I tested on 2019 and found no exceptions. This is not a compatibility issue. If it is not running on the server, it is recommended that you upgrade to the appropriate 2019 version.

SELECT compatibility_level FROM sys.databases WHERE name = 'mybase'  
select @@VERSION  
select * from STRING_SPLIT('2,2,2,2',',')  
select * from string_split('2,2,2,2',',')  

Best regards,
Bert Zhou

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Looks like bug is still present in SSMS 18.10 I see a red underline and error message about insufficient number of arguments. The function itself works fine, though, in SQL 2019 and in SQL 2016.