Interface SqlFunctions.ISqlServerRegexpMatchRow
Row shape produced by regexp_matches(string?, string?): SQL Server
2025 returns one row per match with match_id bigint, the one-based start_position int
and end_position int, the matched text as match_value varchar(n) and the capture
groups as the engine's JSON text in substring_matches varchar(max). The
substring_matches column is carried as an opaque string: its length is not fixed by the
input, so it is never cast or truncated by the provider.
public interface SqlFunctions.ISqlServerRegexpMatchRow
- Extension Methods
Properties
EndPosition
The one-based position of the last character of the match.
[Column("end_position")]
int EndPosition { get; set; }
Property Value
MatchId
The one-based match number.
[Column("match_id")]
long MatchId { get; set; }
Property Value
MatchValue
The matched text.
[Column("match_value")]
string? MatchValue { get; set; }
Property Value
StartPosition
The one-based position of the first character of the match.
[Column("start_position")]
int StartPosition { get; set; }
Property Value
SubstringMatches
The capture groups as the engine's JSON text (varchar(max)), never truncated.
[Column("substring_matches")]
string? SubstringMatches { get; set; }