Class LikeOperandSql

Assembly: redb.Core.Pro.dll

BR-7 (2026-09-02): the operand of the StartsWith/EndsWith/Contains sugar (+IgnoreCase) is a
LITERAL by contract - '%'/'_' must not act as LIKE wildcards, '[' must not open a T-SQL
character class, and a backslash must not act as the escape character. The Pro builders splice
the operand into the pattern inside SQL (col LIKE || '%'), so the escaping wraps the
operand expression in SQL too - deliberately with the engines' built-in replace() and
NOT the bundle's pvt_like_escape(): a Pro assembly must not require a bundle version
(deployment skew would turn every string search into an undefined-function error).

The ESCAPE clause is the call site's duty: PostgreSQL's default escape is already the
backslash; SQLite and MSSQL sites must append ESCAPE '\' themselves. The raw
$like/$ilike operators never pass through here - the pattern belongs to the caller.

public static class LikeOperandSql

Inheritance

Object→LikeOperandSql

Methods

MsSql(string)

Wraps an operand SQL expression for MSSQL LIKE.

public static string MsSql(string operandSql)

PgSqlite(string)

Wraps an operand SQL expression for PostgreSQL/SQLite LIKE.

public static string PgSqlite(string operandSql)