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

Case Sensitivity in Searches

Question:
How can I ignore case when trying to SELECT all records that are LIKE a certain string variable? I have an employee's name field in which the characters are a combination of lower and upper case letters. I do not want users to be concerned about case when doing searches.

Answer:
The easiest solution is to write your queries using the UPPER() function (or whatever exact syntax your product supports):

    ... WHERE UPPER(column)='NAME';
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