Wildcards for Find and Replace
Last modified: October 8, 2024
Having selected Use in the Find and Replace window, choose Wildcards. The following set of expressions unlocks:
Expression | Syntax | Description |
Zero or more of any character | * |
Matches zero or more occurrences of the preceding expression, making all possible matches. |
Any single character | ? |
Matches any single character except a line break. |
Any single digit | # |
Matches any single digit. For example, 8# matches numbers that include 8 followed by another number, such as 81, but not 18. |
Any one character in the set | [] |
Matches any one of the characters within the []. |
Any one character not in the set | [! ] |
Matches any character that is not specified in the set. |
Escape Special Character | \ |
Matches the character that follows the backslash as a literal. This allows you to find the characters used in regular expression notation, such as { and ^. |
Was this page helpful?
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by Data Generator for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.