MssqlTextOperators extension

The text predicates, on expressions whose SQL type is text.

Not on every expression: total.contains('5') would ask SQL Server to LIKE a decimal, which either converts the column or fails. A generated numeric column therefore does not have these, while an untyped Col('Name') still does, since nothing is known about it.

on

• MssqlTextExpression

Methods

contains(String term) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

LIKE '%term%', with term escaped.

endsWith(String term) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

LIKE '%term', with term escaped.

like(String pattern) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

LIKE, with %, _ and [ in pattern treated as literal text.

likeRaw(String pattern) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

LIKE with pattern passed through unescaped, wildcards and all.

notContains(String term) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

notLike(String pattern) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

notLikeRaw(String pattern) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

startsWith(String term) → MssqlCondition

Available on MssqlTextExpression, provided by the MssqlTextOperators extension

LIKE 'term%', with term escaped.