Wildcards for Find and Replace
The Find and Replace window in dbForge Studio for SQL Server contains a list of expressions to replace characters or digits in the Find what field. They are called Wildcards.
To select a required wildcard, do the following:
- In the Find and Replace window, select the Use check box and choose Wildcards from the drop-down list. The Arrow_Button arrow button next to the Find what field becomes active.
- Click the arrow button and select a wildcard from the drop-down list. It is inserted into the Find what field.
The drop-down list contains the following wildcards:
| Syntax | Expression | Description |
|---|---|---|
| ? | Any single character | Matches any single character. |
| # | Any single digit | Matches any single digit. For example, 5# matches numbers that include 5 followed by another number, such as 51, but not 15. |
| [!] | Characters not in set | Matches any one character that is not specified in the set. |
| | Escape | Matches the character that follows the backslash () as a literal. This allows you to find the characters used in wildcard notation, such as * and #. | |
| * | One or more characters | Matches any one or more characters. For example, test* matches any text that includes “test”, such as testfile.txt. |
| [] | Set of characters | Matches any one of the characters specified in the set. |
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?