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: Visual FoxPro
Expertise: Beginner
Feb 8, 2000

Query Returning Case-Insensitive Matches

Question:
Using ASP and ODBC, I can query Microsoft Access databases using the "Like" operator with the wildcard %, such as:
Select * from customers where lastname Like '%jon%'
The query returns case-insensitive matches (Jones, jones, etc.)

When using the "Like" operator with a Visual FoxPro query, however, the query returns case-sensitive matches (jones, but not Jones).

How can I duplicate the case-insensitive query when using the FoxPro database?

Answer:
Try the following:

Select * from customers where UPPER(lastname) Like '%JON%'
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