Searching and Filtering Database Information
•Percent Sign % matches a string of zero, one, or more unknown characters.
Example, % will match any word or phrase with any number and type of characters.
•Underscore _ matches any single unknown character.
Example, Column_ will match Columns or Column5 but will not match ColumnName or Column15.
Example, Column__ will match Column A or Column15 but will not match ColumnName or Column5.
•Square Brackets [ ] can be used to match any single character within the specified range or set.
Example, Sample[A-Z] would match SampleA or SampleB but would not match Sample1 or Sample2.
Example, Sample would match Sample1 or Sample5 but would not match Sample2 or SampleA.
•Square Brackets with Caret [ ^ ] can be used to match any single character not within the specified range or set.
Example, Sample[!A-Z] would match Sample2 or Sample8 but would not match SampleA or SampleB.
Example, Sample[!135] would match Sample8 or SampleA but would not match Sample1 or Sample5.
Copyright © 2023 pasUNITY, Inc.
Send comments on this topic.