Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Mar 25, 1997

Wildcard Searches in SQL

Question:
Are wildcards allowed when trying to match the contents of a textfield as in the following example?
    SELECT * FROM Database WHERE textfield = 'B*'

Answer:
Yes, but you'll need to use the LIKE clause instead of the equal sign, and the wildcard character in SQL is the percent sign. Your correct syntax will be:

    SELECT * FROM Database WHERE textfield LIKE 'B%';
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date