Give us feedback
sql-wildcard-escaper
Service icon

SQL Wildcard Escaper

Stable version 1.0.0 (Compatible with OutSystems 11)
Uploaded on 29 August 2022 by 
0.0
 (0 ratings)
sql-wildcard-escaper

SQL Wildcard Escaper

Details
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)