Which of the following is a wildcard character in Access?

Wildcard characters are used with the LIKE operator. The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

Nội dung chính Show

Wildcard Characters in MS Access
Wildcard Characters in SQL Server
Demo Database
Using the % Wildcard
Using the _ Wildcard
Using the [charlist] Wildcard
Using the [!charlist] Wildcard
What is a wildcard character in access?
Which of the following characters is a wildcard?
What is wildcards name?

Wildcard Characters in MS Access

SymbolDescriptionExample*Represents zero or more charactersbl* finds bl, black, blue, and blob?Represents a single characterh?t finds hot, hat, and hit[]Represents any single character within the bracketsh[oa]t finds hot and hat, but not hit!Represents any character not in the bracketsh[!oa]t finds hit, but not hot and hat-Represents any single character within the specified rangec[a-b]t finds cat and cbt#Represents any single numeric character2#5 finds 205, 215, 225, 235, 245, 255, 265, 275, 285, and 295

Wildcard Characters in SQL Server

SymbolDescriptionExample%Represents zero or more charactersbl% finds bl, black, blue, and blob_Represents a single characterh_t finds hot, hat, and hit[]Represents any single character within the bracketsh[oa]t finds hot and hat, but not hit^Represents any character not in the bracketsh[^oa]t finds hit, but not hot and hat-Represents any single character within the specified rangec[a-b]t finds cat and cbt

All the wildcards can also be used in combinations!

Here are some examples showing different LIKE operators with '%' and '_' wildcards:

LIKE OperatorDescriptionWHERE CustomerName LIKE 'a%'Finds any values that starts with "a"WHERE CustomerName LIKE '%a'Finds any values that ends with "a"WHERE CustomerName LIKE '%or%'Finds any values that have "or" in any positionWHERE CustomerName LIKE '_r%'Finds any values that have "r" in the second positionWHERE CustomerName LIKE 'a__%'Finds any values that starts with "a" and are at least 3 characters in lengthWHERE ContactName LIKE 'a%o'Finds any values that starts with "a" and ends with "o"

Demo Database

The table below shows the complete "Customers" table from the Northwind sample database:

CustomerIDCustomerNameContactNameAddressCityPostalCodeCountry1Alfreds FutterkisteMaria AndersObere Str. 57Berlin12209Germany2Ana Trujillo Emparedados y heladosAna TrujilloAvda. de la Constitución 2222México D.F.05021Mexico3Antonio Moreno TaqueríaAntonio MorenoMataderos 2312México D.F.05023Mexico4Around the HornThomas Hardy120 Hanover Sq.LondonWA1 1DPUK5Berglunds snabbköpChristina BerglundBerguvsvägen 8LuleåS-958 22Sweden6Blauer See DelikatessenHanna MoosForsterstr. 57Mannheim68306Germany7Blondel père et filsFrédérique Citeaux24, place KléberStrasbourg67000France8Bólido Comidas preparadasMartín SommerC/ Araquil, 67Madrid28023Spain9Bon app'Laurence Lebihans12, rue des BouchersMarseille13008France10Bottom-Dollar MarketseElizabeth Lincoln23 Tsawassen Blvd.TsawassenT2F 8M4Canada11B's BeveragesVictoria AshworthFauntleroy CircusLondonEC2 5NTUK12Cactus Comidas para llevarPatricio SimpsonCerrito 333Buenos Aires1010Argentina13Centro comercial MoctezumaFrancisco ChangSierras de Granada 9993México D.F.05022Mexico14Chop-suey ChineseYang WangHauptstr. 29Bern3012Switzerland15Comércio MineiroPedro AfonsoAv. dos Lusíadas, 23São Paulo05432-043Brazil16Consolidated HoldingsElizabeth BrownBerkeley Gardens 12 BreweryLondonWX1 6LTUK17Drachenblut DelikatessendSven OttliebWalserweg 21Aachen52066Germany18Du monde entierJanine Labrune67, rue des Cinquante OtagesNantes44000France19Eastern ConnectionAnn Devon35 King GeorgeLondonWX3 6FWUK20Ernst HandelRoland MendelKirchgasse 6Graz8010Austria21Familia ArquibaldoAria CruzRua Orós, 92São Paulo05442-030Brazil22FISSA Fabrica Inter. Salchichas S.A.Diego RoelC/ Moralzarzal, 86Madrid28034Spain23Folies gourmandesMartine Rancé184, chaussée de TournaiLille59000France24Folk och fä HBMaria LarssonÅkergatan 24BräckeS-844 67Sweden25FrankenversandPeter FrankenBerliner Platz 43München80805Germany26France restaurationCarine Schmitt54, rue RoyaleNantes44000France27Franchi S.p.A.Paolo AccortiVia Monte Bianco 34Torino10100Italy28Furia Bacalhau e Frutos do MarLino RodriguezJardim das rosas n. 32Lisboa1675Portugal29Galería del gastrónomoEduardo SaavedraRambla de Cataluña, 23Barcelona08022Spain30Godos Cocina TípicaJosé Pedro FreyreC/ Romero, 33Sevilla41101Spain31Gourmet LanchonetesAndré FonsecaAv. Brasil, 442Campinas04876-786Brazil32Great Lakes Food MarketHoward Snyder2732 Baker Blvd.Eugene97403USA33GROSELLA-RestauranteManuel Pereira5ª Ave. Los Palos GrandesCaracas1081Venezuela34Hanari CarnesMario PontesRua do Paço, 67Rio de Janeiro05454-876Brazil35HILARIÓN-AbastosCarlos HernándezCarrera 22 con Ave. Carlos Soublette #8-35San Cristóbal5022Venezuela36Hungry Coyote Import StoreYoshi LatimerCity Center Plaza 516 Main St.Elgin97827USA37Hungry Owl All-Night GrocersPatricia McKenna8 Johnstown RoadCorkIreland38Island TradingHelen BennettGarden House Crowther WayCowesPO31 7PJUK39Königlich EssenPhilip CramerMaubelstr. 90Brandenburg14776Germany40La corne d'abondanceDaniel Tonini67, avenue de l'EuropeVersailles78000France41La maison d'AsieAnnette Roulet1 rue Alsace-LorraineToulouse31000France42Laughing Bacchus Wine CellarsYoshi Tannamuri1900 Oak St.VancouverV3F 2K1Canada43Lazy K Kountry StoreJohn Steel12 Orchestra TerraceWalla Walla99362USA44Lehmanns MarktstandRenate MessnerMagazinweg 7Frankfurt a.M.60528Germany45Let's Stop N ShopJaime Yorres87 Polk St. Suite 5San Francisco94117USA46LILA-SupermercadoCarlos GonzálezCarrera 52 con Ave. Bolívar #65-98 Llano LargoBarquisimeto3508Venezuela47LINO-DelicatesesFelipe IzquierdoAve. 5 de Mayo PorlamarI. de Margarita4980Venezuela48Lonesome Pine RestaurantFran Wilson89 Chiaroscuro Rd.Portland97219USA49Magazzini Alimentari RiunitiGiovanni RovelliVia Ludovico il Moro 22Bergamo24100Italy50Maison DeweyCatherine DeweyRue Joseph-Bens 532BruxellesB-1180Belgium51Mère PaillardeJean Fresnière43 rue St. LaurentMontréalH1J 1C3Canada52Morgenstern GesundkostAlexander FeuerHeerstr. 22Leipzig04179Germany53North/SouthSimon CrowtherSouth House 300 QueensbridgeLondonSW7 1RZUK54Océano Atlántico Ltda.Yvonne MoncadaIng. Gustavo Moncada 8585 Piso 20-ABuenos Aires1010Argentina55Old World DelicatessenRene Phillips2743 Bering St.Anchorage99508USA56Ottilies KäseladenHenriette PfalzheimMehrheimerstr. 369Köln50739Germany57Paris spécialitésMarie Bertrand265, boulevard CharonneParis75012France58Pericles Comidas clásicasGuillermo FernándezCalle Dr. Jorge Cash 321México D.F.05033Mexico59Piccolo und mehrGeorg PippsGeislweg 14Salzburg5020Austria60Princesa Isabel VinhossIsabel de CastroEstrada da saúde n. 58Lisboa1756Portugal61Que DelíciaBernardo BatistaRua da Panificadora, 12Rio de Janeiro02389-673Brazil62Queen CozinhaLúcia CarvalhoAlameda dos Canàrios, 891São Paulo05487-020Brazil63QUICK-StopHorst KlossTaucherstraße 10Cunewalde01307Germany64Rancho grandeSergio GutiérrezAv. del Libertador 900Buenos Aires1010Argentina65Rattlesnake Canyon GroceryPaula Wilson2817 Milton Dr.Albuquerque87110USA66Reggiani CaseificiMaurizio MoroniStrada Provinciale 124Reggio Emilia42100Italy67Ricardo AdocicadosJanete LimeiraAv. Copacabana, 267Rio de Janeiro02389-890Brazil68Richter SupermarktMichael HolzGrenzacherweg 237Genève1203Switzerland69Romero y tomilloAlejandra CaminoGran Vía, 1Madrid28001Spain70Santé GourmetJonas BergulfsenErling Skakkes gate 78Stavern4110Norway71Save-a-lot MarketsJose Pavarotti187 Suffolk Ln.Boise83720USA72Seven Seas ImportsHari Kumar90 Wadhurst Rd.LondonOX15 4NBUK73Simons bistroJytte PetersenVinbæltet 34København1734Denmark74Spécialités du mondeDominique Perrier25, rue LauristonParis75016France75Split Rail Beer & AleArt BraunschweigerP.O. Box 555Lander82520USA76Suprêmes délicesPascale CartrainBoulevard Tirou, 255CharleroiB-6000Belgium77The Big CheeseLiz Nixon89 Jefferson Way Suite 2Portland97201USA78The Cracker BoxLiu Wong55 Grizzly Peak Rd.Butte59801USA79Toms SpezialitätenKarin JosephsLuisenstr. 48Münster44087Germany80Tortuga RestauranteMiguel Angel PaolinoAvda. Azteca 123México D.F.05033Mexico81Tradição HipermercadosAnabela DominguesAv. Inês de Castro, 414São Paulo05634-030Brazil82Trail's Head Gourmet ProvisionersHelvetius Nagy722 DaVinci Blvd.Kirkland98034USA83VaffeljernetPalle IbsenSmagsløget 45Århus8200Denmark84Victuailles en stockMary Saveley2, rue du CommerceLyon69004France85Vins et alcools ChevalierPaul Henriot59 rue de l'AbbayeReims51100France86Die Wandernde KuhRita MüllerAdenauerallee 900Stuttgart70563Germany87Wartian HerkkuPirkko KoskitaloTorikatu 38Oulu90110Finland88Wellington ImportadoraPaula ParenteRua do Mercado, 12Resende08737-363Brazil89White Clover MarketsKarl Jablonski305 - 14th Ave. S. Suite 3BSeattle98128USA90Wilman KalaMatti KarttunenKeskuskatu 45Helsinki21240Finland91WolskiZbyszekul. Filtrowa 68Walla01-012Poland

Using the % Wildcard

The following SQL statement selects all customers with a City starting with "ber":

The following SQL statement selects all customers with a City containing the pattern "es":

Using the _ Wildcard

The following SQL statement selects all customers with a City starting with any character, followed by "ondon":

The following SQL statement selects all customers with a City starting with "L", followed by any character, followed by "n", followed by any character, followed by "on":

Using the [charlist] Wildcard

The following SQL statement selects all customers with a City starting with "b", "s", or "p":

The following SQL statement selects all customers with a City starting with "a", "b", or "c":

Using the [!charlist] Wildcard

The two following SQL statements select all customers with a City NOT starting with "b", "s", or "p":

What is a wildcard character in access?

Wildcards are special characters that can stand in for unknown characters in a text value and are handy for locating multiple items with similar, but not identical data. Wildcards can also help with getting data based on a specified pattern match. For example, finding everyone named John on Park Street.

Which of the following characters is a wildcard?

The most common wildcards are the asterisk (*), which represents one or more characters, and question mark (?), which represents a single character.

What is wildcards name?

A wildcard is a character used to represent an unspecified resource name or an unspecified part of a resource name. It is used by the VTAM® operator to broaden the scope of a display or to find the name of a resource.