Give us feedback
Service icon

SQL Wildcard Escaper

Stable version 1.0.0 (Compatible with OutSystems 11)
Uploaded on 29 August 2022 by 
 (0 ratings)

SQL Wildcard Escaper

Can't you search a query for a percentage symbol, underscore or square brackets? Use this service to escape the wildcards of a string so it can be used to search with wildcards (parenthesis, percentage symbol, square brackets and underscore)
Read more

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.

Release notes (1.0.0)
Reviews (0)