Escape free text for interpolation into a SQL Server LIKE pattern: quotes doubled so the
string literal stays closed, and %, _, [ bracketed so a user typing "50%" or "a_b" gets
literal matches instead of live wildcards.
Bracketing rather than an ESCAPE clause, so a caller can drop the result into an existing
pattern without also having to declare an escape character.
Escape free text for interpolation into a SQL Server
LIKEpattern: quotes doubled so the string literal stays closed, and%,_,[bracketed so a user typing "50%" or "a_b" gets literal matches instead of live wildcards.Bracketing rather than an
ESCAPEclause, so a caller can drop the result into an existing pattern without also having to declare an escape character.