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[135] 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 © 2024 pasUNITY, Inc.

 

Send comments on this topic.