More Characters

SQL Wildcard Characters

MSAgent Webring - More Popular Characters can be found here The Agentry - with over 300 Agent Characters listed More Characters are also included on the CyberBuddy Premium Version And don't forget to check the CyberBuddy Home Made Character Page. AND CyberBuddy Sites Page. Learn about your favorite Marvel characters, super heroes, & villains! Discover their powers, weaknesses, abilities, & more!

A wildcard character is used to substitute one or more characters in a string.

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

Wildcard Characters in MS Access

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

Wildcard Characters in SQL Server

Symbol	Description	Example
%	Represents zero or more characters	bl% finds bl, black, blue, and blob
_	Represents a single character	h_t finds hot, hat, and hit
[]	Represents any single character within the brackets	h[oa]t finds hot and hat, but not hit
^	Represents any character not in the brackets	h[^oa]t finds hit, but not hot and hat
-	Represents a range of characters	c[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 Operator	Description
WHERE 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 position
WHERE CustomerName LIKE '_r%'	Finds any values that have 'r' in the second position
WHERE CustomerName LIKE 'a_%_%'	Finds any values that starts with 'a' and are at least 3 characters in length
WHERE 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:

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country
1	Alfreds Futterkiste	Maria Anders	Obere Str. 57	Berlin	12209	Germany
2	Ana Trujillo Emparedados y helados	Ana Trujillo	Avda. de la Constitución 2222	México D.F.	05021	Mexico
3	Antonio Moreno Taquería	Antonio Moreno	Mataderos 2312	México D.F.	05023	Mexico
4	Around the Horn	Thomas Hardy	120 Hanover Sq.	London	WA1 1DP	UK
5	Berglunds snabbköp	Christina Berglund	Berguvsvägen 8	Luleå	S-958 22	Sweden
6	Blauer See Delikatessen	Hanna Moos	Forsterstr. 57	Mannheim	68306	Germany
7	Blondel père et fils	Frédérique Citeaux	24, place Kléber	Strasbourg	67000	France
8	Bólido Comidas preparadas	Martín Sommer	C/ Araquil, 67	Madrid	28023	Spain
9	Bon app'	Laurence Lebihans	12, rue des Bouchers	Marseille	13008	France
10	Bottom-Dollar Marketse	Elizabeth Lincoln	23 Tsawassen Blvd.	Tsawassen	T2F 8M4	Canada
11	B's Beverages	Victoria Ashworth	Fauntleroy Circus	London	EC2 5NT	UK
12	Cactus Comidas para llevar	Patricio Simpson	Cerrito 333	Buenos Aires	1010	Argentina
13	Centro comercial Moctezuma	Francisco Chang	Sierras de Granada 9993	México D.F.	05022	Mexico
14	Chop-suey Chinese	Yang Wang	Hauptstr. 29	Bern	3012	Switzerland
15	Comércio Mineiro	Pedro Afonso	Av. dos Lusíadas, 23	São Paulo	05432-043	Brazil
16	Consolidated Holdings	Elizabeth Brown	Berkeley Gardens 12 Brewery	London	WX1 6LT	UK
17	Drachenblut Delikatessend	Sven Ottlieb	Walserweg 21	Aachen	52066	Germany
18	Du monde entier	Janine Labrune	67, rue des Cinquante Otages	Nantes	44000	France
19	Eastern Connection	Ann Devon	35 King George	London	WX3 6FW	UK
20	Ernst Handel	Roland Mendel	Kirchgasse 6	Graz	8010	Austria
21	Familia Arquibaldo	Aria Cruz	Rua Orós, 92	São Paulo	05442-030	Brazil
22	FISSA Fabrica Inter. Salchichas S.A.	Diego Roel	C/ Moralzarzal, 86	Madrid	28034	Spain
23	Folies gourmandes	Martine Rancé	184, chaussée de Tournai	Lille	59000	France
24	Folk och fä HB	Maria Larsson	Åkergatan 24	Bräcke	S-844 67	Sweden
25	Frankenversand	Peter Franken	Berliner Platz 43	München	80805	Germany
26	France restauration	Carine Schmitt	54, rue Royale	Nantes	44000	France
27	Franchi S.p.A.	Paolo Accorti	Via Monte Bianco 34	Torino	10100	Italy
28	Furia Bacalhau e Frutos do Mar	Lino Rodriguez	Jardim das rosas n. 32	Lisboa	1675	Portugal
29	Galería del gastrónomo	Eduardo Saavedra	Rambla de Cataluña, 23	Barcelona	08022	Spain
30	Godos Cocina Típica	José Pedro Freyre	C/ Romero, 33	Sevilla	41101	Spain
31	Gourmet Lanchonetes	André Fonseca	Av. Brasil, 442	Campinas	04876-786	Brazil
32	Great Lakes Food Market	Howard Snyder	2732 Baker Blvd.	Eugene	97403	USA
33	GROSELLA-Restaurante	Manuel Pereira	5ª Ave. Los Palos Grandes	Caracas	1081	Venezuela
34	Hanari Carnes	Mario Pontes	Rua do Paço, 67	Rio de Janeiro	05454-876	Brazil
35	HILARIÓN-Abastos	Carlos Hernández	Carrera 22 con Ave. Carlos Soublette #8-35	San Cristóbal	5022	Venezuela
36	Hungry Coyote Import Store	Yoshi Latimer	City Center Plaza 516 Main St.	Elgin	97827	USA
37	Hungry Owl All-Night Grocers	Patricia McKenna	8 Johnstown Road	Cork	Ireland
38	Island Trading	Helen Bennett	Garden House Crowther Way	Cowes	PO31 7PJ	UK
39	Königlich Essen	Philip Cramer	Maubelstr. 90	Brandenburg	14776	Germany
40	La corne d'abondance	Daniel Tonini	67, avenue de l'Europe	Versailles	78000	France
41	La maison d'Asie	Annette Roulet	1 rue Alsace-Lorraine	Toulouse	31000	France
42	Laughing Bacchus Wine Cellars	Yoshi Tannamuri	1900 Oak St.	Vancouver	V3F 2K1	Canada
43	Lazy K Kountry Store	John Steel	12 Orchestra Terrace	Walla Walla	99362	USA
44	Lehmanns Marktstand	Renate Messner	Magazinweg 7	Frankfurt a.M.	60528	Germany
45	Let's Stop N Shop	Jaime Yorres	87 Polk St. Suite 5	San Francisco	94117	USA
46	LILA-Supermercado	Carlos González	Carrera 52 con Ave. Bolívar #65-98 Llano Largo	Barquisimeto	3508	Venezuela
47	LINO-Delicateses	Felipe Izquierdo	Ave. 5 de Mayo Porlamar	I. de Margarita	4980	Venezuela
48	Lonesome Pine Restaurant	Fran Wilson	89 Chiaroscuro Rd.	Portland	97219	USA
49	Magazzini Alimentari Riuniti	Giovanni Rovelli	Via Ludovico il Moro 22	Bergamo	24100	Italy
50	Maison Dewey	Catherine Dewey	Rue Joseph-Bens 532	Bruxelles	B-1180	Belgium
51	Mère Paillarde	Jean Fresnière	43 rue St. Laurent	Montréal	H1J 1C3	Canada
52	Morgenstern Gesundkost	Alexander Feuer	Heerstr. 22	Leipzig	04179	Germany
53	North/South	Simon Crowther	South House 300 Queensbridge	London	SW7 1RZ	UK
54	Océano Atlántico Ltda.	Yvonne Moncada	Ing. Gustavo Moncada 8585 Piso 20-A	Buenos Aires	1010	Argentina
55	Old World Delicatessen	Rene Phillips	2743 Bering St.	Anchorage	99508	USA
56	Ottilies Käseladen	Henriette Pfalzheim	Mehrheimerstr. 369	Köln	50739	Germany
57	Paris spécialités	Marie Bertrand	265, boulevard Charonne	Paris	75012	France
58	Pericles Comidas clásicas	Guillermo Fernández	Calle Dr. Jorge Cash 321	México D.F.	05033	Mexico
59	Piccolo und mehr	Georg Pipps	Geislweg 14	Salzburg	5020	Austria
60	Princesa Isabel Vinhoss	Isabel de Castro	Estrada da saúde n. 58	Lisboa	1756	Portugal
61	Que Delícia	Bernardo Batista	Rua da Panificadora, 12	Rio de Janeiro	02389-673	Brazil
62	Queen Cozinha	Lúcia Carvalho	Alameda dos Canàrios, 891	São Paulo	05487-020	Brazil
63	QUICK-Stop	Horst Kloss	Taucherstraße 10	Cunewalde	01307	Germany
64	Rancho grande	Sergio Gutiérrez	Av. del Libertador 900	Buenos Aires	1010	Argentina
65	Rattlesnake Canyon Grocery	Paula Wilson	2817 Milton Dr.	Albuquerque	87110	USA
66	Reggiani Caseifici	Maurizio Moroni	Strada Provinciale 124	Reggio Emilia	42100	Italy
67	Ricardo Adocicados	Janete Limeira	Av. Copacabana, 267	Rio de Janeiro	02389-890	Brazil
68	Richter Supermarkt	Michael Holz	Grenzacherweg 237	Genève	1203	Switzerland
69	Romero y tomillo	Alejandra Camino	Gran Vía, 1	Madrid	28001	Spain
70	Santé Gourmet	Jonas Bergulfsen	Erling Skakkes gate 78	Stavern	4110	Norway
71	Save-a-lot Markets	Jose Pavarotti	187 Suffolk Ln.	Boise	83720	USA
72	Seven Seas Imports	Hari Kumar	90 Wadhurst Rd.	London	OX15 4NB	UK
73	Simons bistro	Jytte Petersen	Vinbæltet 34	København	1734	Denmark
74	Spécialités du monde	Dominique Perrier	25, rue Lauriston	Paris	75016	France
75	Split Rail Beer & Ale	Art Braunschweiger	P.O. Box 555	Lander	82520	USA
76	Suprêmes délices	Pascale Cartrain	Boulevard Tirou, 255	Charleroi	B-6000	Belgium
77	The Big Cheese	Liz Nixon	89 Jefferson Way Suite 2	Portland	97201	USA
78	The Cracker Box	Liu Wong	55 Grizzly Peak Rd.	Butte	59801	USA
79	Toms Spezialitäten	Karin Josephs	Luisenstr. 48	Münster	44087	Germany
80	Tortuga Restaurante	Miguel Angel Paolino	Avda. Azteca 123	México D.F.	05033	Mexico
81	Tradição Hipermercados	Anabela Domingues	Av. Inês de Castro, 414	São Paulo	05634-030	Brazil
82	Trail's Head Gourmet Provisioners	Helvetius Nagy	722 DaVinci Blvd.	Kirkland	98034	USA
83	Vaffeljernet	Palle Ibsen	Smagsløget 45	Århus	8200	Denmark
84	Victuailles en stock	Mary Saveley	2, rue du Commerce	Lyon	69004	France
85	Vins et alcools Chevalier	Paul Henriot	59 rue de l'Abbaye	Reims	51100	France
86	Die Wandernde Kuh	Rita Müller	Adenauerallee 900	Stuttgart	70563	Germany
87	Wartian Herkku	Pirkko Koskitalo	Torikatu 38	Oulu	90110	Finland
88	Wellington Importadora	Paula Parente	Rua do Mercado, 12	Resende	08737-363	Brazil
89	White Clover Markets	Karl Jablonski	305 - 14th Ave. S. Suite 3B	Seattle	98128	USA
90	Wilman Kala	Matti Karttunen	Keskuskatu 45	Helsinki	21240	Finland
91	Wolski	Zbyszek	ul. Filtrowa 68	Walla	01-012	Poland

Using the % Wildcard

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

Example

Try it Yourself »

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

Example

Try it Yourself »

Using the _ Wildcard

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

Example

SELECT * FROM Customers
WHERE City LIKE '_ondon';

Try it Yourself »

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':

Example

SELECT * FROM Customers
WHERE City LIKE 'L_n_on';

Try it Yourself »

Using the [charlist] Wildcard

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

Example

SELECT * FROM Customers
WHERE City LIKE '[bsp]%';

Try it Yourself »

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

Example

More Character Models

SELECT * FROM Customers
WHERE City LIKE '[a-c]%';

Try it Yourself »

Using the [!charlist] Wildcard

More Character Models

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

Example

SELECT * FROM Customers
WHERE City LIKE '[!bsp]%';

Try it Yourself »

Or:

Example

More Characters Mod Sonic Mania

SELECT * FROM Customers
WHERE City NOT LIKE '[bsp]%';

Try it Yourself »

More Characters In Doble Kara Cast 2016

More Characters In Avengers Game

Character	Sequence
backspace†	Alt 8
tab†	Alt 9
line break†	Alt 10
､	Alt 15
ｶ	Alt 20
ｧ	Alt 21
paste†	Alt 22
space†	Alt 32
!	Alt 33
'	Alt 34
#	Alt 35
$	Alt 36
%	Alt 37
&	Alt 38
'	Alt 39
(	Alt 40
)	Alt 41
*	Alt 42
+	Alt 43
,	Alt 44
-	Alt 45
.	Alt 46
/	Alt 47
0	Alt 48
1	Alt 49
2	Alt 50
3	Alt 51
4	Alt 52
5	Alt 53
6	Alt 54
7	Alt 55
8	Alt 56
9	Alt 57
:	Alt 58
;	Alt 59
<	Alt 60
=	Alt 61
>	Alt 62
?	Alt 63
@	Alt 64
A	Alt 65
B	Alt 66
C	Alt 67
D	Alt 68

Character	Sequence
E	Alt 69
F	Alt 70
G	Alt 71
H	Alt 72
I	Alt 73
J	Alt 74
K	Alt 75
L	Alt 76
M	Alt 77
N	Alt 78
O	Alt 79
P	Alt 80
Q	Alt 81
R	Alt 82
S	Alt 83
T	Alt 84
U	Alt 85
V	Alt 86
W	Alt 87
X	Alt 88
Y	Alt 89
Z	Alt 90
[	Alt 91
	Alt 92
]	Alt 93
^	Alt 94
_	Alt 95
`	Alt 96
a	Alt 97
b	Alt 98
c	Alt 99
d	Alt 100
e	Alt 101
f	Alt 102
g	Alt 103
h	Alt 104
i	Alt 105
j	Alt 106
k	Alt 107
l	Alt 108
m	Alt 109
n	Alt 110
o	Alt 111
p	Alt 112

Character	Sequence
q	Alt 113
r	Alt 114
s	Alt 115
t	Alt 116
u	Alt 117
v	Alt 118
w	Alt 119
x	Alt 120
y	Alt 121
z	Alt 122
{	Alt 123
\|	Alt 124
}	Alt 125
~	Alt 126
001a	Alt 127
ﾇ	Alt 128
001a	Alt 129
001a	Alt 130
001a	Alt 131
001a	Alt 132
001a	Alt 133
001a	Alt 134
001a	Alt 135
001a	Alt 136
001a	Alt 137
001a	Alt 138
001a	Alt 139
001a	Alt 140
001a	Alt 141
001a	Alt 145
ﾆ	Alt 146
001a	Alt 147
001a	Alt 148
001a	Alt 149
001a	Alt 150
001a	Alt 151
001a	Alt 152
｢	Alt 155
｣	Alt 156
･	Alt 157
P	Alt 158
001a	Alt 159
001a	Alt 160
001a	Alt 161

Character	Sequence
001a	Alt 162
001a	Alt 163
001a	Alt 164
ﾑ	Alt 165
Alt 166‡
Alt 167‡
ｿ	Alt 168
ｬ	Alt 170
ｽ	Alt 171
ｼ	Alt 172
｡	Alt 173
ｫ	Alt 174
ｻ	Alt 175
ｦ	Alt 179
ﾟ	Alt 225
ｵ	Alt 230
ｱ	Alt 241
ｰ	Alt 248
001a	Alt 249
ｷ	Alt 250
ｲ	Alt 253
€	Alt 0128
„	Alt 0132
…	Alt 0133
†	Alt 0134
‡	Alt 0135
ˆ	Alt 0136
‰	Alt 0137
Š	Alt 0138
‹	Alt 0139
Œ	Alt 0140
‘	Alt 0145
’	Alt 0146
“	Alt 0147
”	Alt 0148
–	Alt 0150
—	Alt 0151
˜	Alt 0152
™	Alt 0153
š	Alt 0154
›	Alt 0155
œ	Alt 0156
Ÿ	Alt 0159
¨	Alt 0168

Character	Sequence
©	Alt 0169
®	Alt 0174
¯	Alt 0175
³	Alt 0179
´	Alt 0180
¸	Alt 0184
¹	Alt 0185
¾	Alt 0190
À	Alt 0192
Á	Alt 0193
Â	Alt 0194
Ã	Alt 0195
Ä	Alt 0196
Å	Alt 0197
È	Alt 0200
É	Alt 0201
Ê	Alt 0202
Ë	Alt 0203
Ì	Alt 0204
Í	Alt 0205
Î	Alt 0206
Ï	Alt 0207
Ð	Alt 0208
Ò	Alt 0210
Ó	Alt 0211
Ô	Alt 0212
Õ	Alt 0213
Ö	Alt 0214
×	Alt 0215
Ø	Alt 0216
Ù	Alt 0217
Ú	Alt 0218
Û	Alt 0219
Ü	Alt 0220
Ý	Alt 0221
Þ	Alt 0222
ã	Alt 0227
ð	Alt 0240
õ	Alt 0245
÷	Alt 0247
ø	Alt 0248
ü	Alt 0252
ý	Alt 0253
þ	Alt 0254