Select Query fails

  • Thread starter Thread starter kirkm
  • Start date Start date
K

kirkm

I'm sure this normallly works, but is now failing and I can't see why.

My Select Query is

SELECT [OZburn by Year].Title
FROM [OZburn by Year]
WHERE ((([OZburn by Year].Title)="Back In Your Arms"));

It finds nothing because the source table string is

"Back in Your Arms" with a lower case "i".

How do I ignore whether anything is Upper or Lower case?

Thanks - Kirk
 
Back
Top