WildCards - Helmut-Ortmann/EnterpriseArchitect_hoTools GitHub Wiki

Wildcard

All SQL queries and <Search Term> supports the following wild cards:

• #WC# no or arbitrary characters
• '*' or '%' no or arbitrary characters
• '_' or '?' one random character

hoTools translates the DB particular wild card of the current DB (database).

Examples

• 'myString*' finds everything which starts with 'myString'
• 'myString%' finds everything which starts with 'myString'
• 'myString#WC#' finds everything which starts with 'myString'
• 'my_String' finds everything which starts with 'my' followed by one character and by the string 'String'

Special Wildcards

The lists isn't complete. If you have some advice contact me and I update it.

Access

see: w3schools.com

see: office.com

• # Matches any single numeric character
• [charlist] Defines sets and ranges of characters to match
• [^charlist] Defines sets and ranges of characters NOT to match
• [!charlist] Defines sets and ranges of characters NOT to match
• [#] Escapes the '#'
• [∗] Escapes the '*'

SQL Server

see: w3schools.com

• [charlist] Defines sets and ranges of characters to match
• [^charlist] Defines sets and ranges of characters NOT to match
• [!charlist] Defines sets and ranges of characters NOT to match