We help IT Professionals succeed at work.
Get Started

Search for lowercase instances in a case-insensitive column

ngwsls
ngwsls asked
on
358 Views
Last Modified: 2012-05-09
I have a table in my SQL Server 2005 database that contains customer IDs.  Example:
CULSTA2
culsta2
BILBOA
SUNSUP
AQUCON
aqucon

and so on.  I need to be able to identify anytime there's an entry of any lower case entry, separate from the correct entry of all upper case.  My database is set as case-insensitive but the application that uses it interprets the data differently if it is lower case rather than all upper case.

So in the set shown above, I'd just be looking for culsta2 and aqucon, and NOT CULSTA2 or AQUCON.

Help?
Thanks
Van

Comment
Watch Question
Software Engineer
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE