Explore Courses Blog Tutorials Interview Questions
0 votes
in Azure by (12.7k points)

The new STRING_SPLIT method is not available in my Azure SQL database. I had already ran ALTER DATABASE [DatabaseName] SET COMPATIBILITY_LEVEL = 130 a couple days ago, and I have verified the compatibility level is indeed set to 130. SELECT database_id, name, compatibility_level FROM sys.databases

Has anyone else been able to use the new method, and if so, did you need to do anything else to get it working?

1 Answer

0 votes
by (9.6k points)

Correct Syntax is:

 SELECT Value FROM STRING_SPLIT('Hello World.', ' ');

For more details click here

Browse Categories