Databases

=Tips on Using MS Access= Using *37 allows you to select all records starting with 37 2011MJP2_1 || ||
 * **Using Wildcards** ||  ||
 * [[image:igict2012/db_wildcard.JPG]]
 * There are other wildcards that byou should know about such as ??? ||  ||


 * ~ **CHARACTER** ||~ **DESCRIPTION** ||~ **EXAMPLE** ||
 * * || Matches any number of characters. You can use the asterisk (*****) anywhere in a character string. || **wh*** finds what, white, and why, but not awhile or watch. ||
 * ? || Matches any single alphabetic character. || **B?ll** finds ball, bell, and bill. ||
 * [ ] || Matches any single character within the brackets. || **B[ae]ll** finds ball and bell, but not bill. ||
 * ! || Matches any character not in the brackets. || **b[!ae]ll** finds bill and bull, but not ball or bell. ||
 * - || Matches any one of a range of characters. You must specify the range in ascending order (A to Z, not Z to A). || **b[a-c]d** finds bad, bbd, and bcd. ||
 * # || Matches any single numeric character. || **1#3** finds 103, 113, and 123. ||

Use asterisk to find records that start with 37