MS Access − Wildcards

0 6 Datenblatt sir

Lernen beginnen

Frage		Antworten
Represents zero or more characters Lernen beginnen		* bl* finds bl, black, blue, and blob
Represents a single character Lernen beginnen		? h? t finds hot, hat, and hit
Represents any single character within the brackets Lernen beginnen		[] h[oa]t finds hot and hat, but not hit
Represents any character not in the brackets Lernen beginnen		! h[! oa]t finds hit, but not hot and hat
Represents a range of characters Lernen beginnen		- c[a-b]t finds cat and cbt
Represents any single numeric character Lernen beginnen		# 2#5 finds 205, 215, 225, 235, 245, 255, 265, 275, 285, and 295

English