→ MS Access − Wildcards → Start Learning / Download MP3 Flashcards

start learning

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

MS Access − Wildcards