Case sensitive search string

I have a table with a field that contains both upper and lower case characters.  I want to do a search with SQL in the field regardless of case.  I'm using VB5 with Foxpro5 as database.  Anyone know how to go about it?
Who is Participating?
MoondancerConnect With a Mentor Commented:
20 points refunded, question closed today.
Moondancer - EE Moderator
MinnaAuthor Commented:
Edited text of question
MinnaAuthor Commented:
I don't know what you are talking about.  What do you mean by the table settings?  I tried looking at the table properties but I haven't a clue what you're on about.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.