| author | MikeRayMSFT | |
|---|---|---|
| ms.author | mikeray | |
| ms.reviewer | randolphwest | |
| ms.date | 10/24/2025 | |
| ms.service | sql | |
| ms.topic | include | |
| ms.custom |
|
An expression of a character string.
Can be a constant, variable, or column of character string.
Data types: char, nchar, varchar, or nvarchar.
Note
The REGEXP_LIKE, REGEXP_COUNT, and REGEXP_INSTR functions support LOB types (varchar(max) and nvarchar(max)) up to 2 MB for the string_expression parameter.