DP-800: Developing AI-Enabled Database Solutions

In SQL Server 2025 / SQL database in Microsoft Fabric, the regular-expression functions have an important restriction: LOB types (varchar(max) and nvarchar(max), up to 2 MB) are supported only by REGEXP_LIKE, REGEXP_COUNT, and REGEXP_INSTR. REGEXP_SUBSTR, REGEXP_REPLACE, REGEXP_MATCHES, and REGEXP_SPLIT_TO_TABLE do NOT accept LOB input. Because MessageText is nvarchar(max), you must first cast it to a non-LOB type such as nvarchar(4000) before calling REGEXP_SUBSTR, which is fine here since the ID always appears in the first paragraph (choice B). A case-sensitive COLLATE clause (C) changes matching behavior but does not remove the LOB restriction, TRY_CONVERT to varchar(max) (D) is still a LOB, and STRING_ESCAPE (A) is unrelated.