Visual Basic gives you several ways to provide pattern-matches in a
search string. Typically, you use pattern-matching characters for two
purposes: to search for strings in a VB application's GUI or variable,
or to look for items within a database, such as Access or SQL. When you
search for pattern matches in a database, however, depending on which
database you're using, different characters perform different matches.
The following list shows the different characters used by each database:
Required Match
Keep in mind that when you use Visual Basic's SQL Builder to create SQL
Any single character
Access/VB: ? SQLServer: _
Zero or more characters
Access/VB: * SQLServer: %
Any single digit (0-9)
Access/VB: # SQLServer: n/a
Any single character in charlist
Access/VB: [charlist] SQLServer: [charlist]
Any single character not in charlist
Access/VB: [!charlist] SQLServer: [^charlist]
statements, it only accepts SQL Server pattern-matching characters--even
when you're pulling data from an Access database.
Access, VB and SQL Server wildcard characters
By James Crowley, published on 14 Jul 2001
| Filed in
You might also like...
SQL Server forum discussion
-
problem with select within select
by hamidreza.hr923 (2 replies)
-
convert EMPTY fields to NULL?
by viktorcheberachko (5 replies)
-
how to delete values of a particular column in a table
by sanjaymishra112sm112 (7 replies)
-
Send mail from stored Procedure.
by Mulish Mehdi (3 replies)
-
PROBLEM
by royal ludhiana (2 replies)
SQL Server podcasts
-
Deep Fried Bytes: What is the Big Deal about Big Data?
Published 8 years ago, running time 0h39m
In this episode, Woody sits down with Andrew Brust to discuss another “big” technology for developers and IT professionals: Big Data. Woody and Andrew talk about what Big Data is, who is using it, what tools are available and finally how we has technologists can use this for our products and serv.
SQL Server jobs
-
C# .NET SQL Developer
NMQA in London, United Kingdom
200-400 per day -
Senior Software Engineer
ABX Express (M) Sdn Bhd in Petaling Jaya, Malaysia
$18,000-20,000 USD per year
Comments