MS Access − Wildcards

 0    6 fiche    sir
Télécharger mP3 Imprimer jouer consultez
 
question réponse
Represents zero or more characters
commencer à apprendre
*
bl* finds bl, black, blue, and blob
Represents a single character
commencer à apprendre
?
h? t finds hot, hat, and hit
Represents any single character within the brackets
commencer à apprendre
[]
h[oa]t finds hot and hat, but not hit
Represents any character not in the brackets
commencer à apprendre
!
h[! oa]t finds hit, but not hot and hat
Represents a range of characters
commencer à apprendre
-
c[a-b]t finds cat and cbt
Represents any single numeric character
commencer à apprendre
#
2#5 finds 205, 215, 225, 235, 245, 255, 265, 275, 285, and 295

Vous devez vous connecter pour poster un commentaire.