SqlHelper.EscapeLikeQueryPatterns Method

Escapes characters for query which use LIKE pattern.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 8.2.23

Syntax

public static string EscapeLikeQueryPatterns(
	string input,
	bool escapeUnderScore = true,
	bool escapePercentage = true,
	bool escapeSquareBrackets = true
)

Parameters

input

Type: System.String
Input text

escapeUnderScore (Optional)

Type: System.Boolean
Indicates whether underscore character should be escaped

escapePercentage (Optional)

Type: System.Boolean
Indicates whether percentage character should be escaped

escapeSquareBrackets (Optional)

Type: System.Boolean
Indicates whether square brackets characters should be escaped

Return Value

Type: String