Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in Azure by (12.8k 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

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.6k users

Browse Categories

...