When performing a search via a SQL Server query, it is very common to seek a partial match, which would like "%" + SearchKeyword + "%".

The % of course is a wild card, but there are more:

• % represents zero or more characters    bl% finds bl, black, blue, and blob
• _ represents a single character    h_t finds hot, hat, and hit
• [] represents any single character within the brackets    h[oa]t finds hot and hat, but not hit

Searching by a string with these characters would fail, as they need to be escaped. That's what this component does.