MS Access − Wildcards

 0    6 fiche    sir
laste ned mp3 Skriv ut spille sjekk deg selv
 
spørsmålet svaret
Represents zero or more characters
begynn å lære
*
bl* finds bl, black, blue, and blob
Represents a single character
begynn å lære
?
h? t finds hot, hat, and hit
Represents any single character within the brackets
begynn å lære
[]
h[oa]t finds hot and hat, but not hit
Represents any character not in the brackets
begynn å lære
!
h[! oa]t finds hit, but not hot and hat
Represents a range of characters
begynn å lære
-
c[a-b]t finds cat and cbt
Represents any single numeric character
begynn å lære
#
2#5 finds 205, 215, 225, 235, 245, 255, 265, 275, 285, and 295

Du må logge inn for å legge inn en kommentar.