SELECT * 
FROM Bookings 
WHERE  UPPER(Person) = 'CC'  <-- 
Doesn't work
WHERE  UPPER(Person) = 'AA'  <-- Works
WHERE  Person = 'CC'  <-- Works

---

 Comments and Workarounds

---

CC was also a column name and the inclusion of the UPPER function call around the Person column was preventing the engine from properly determining that 'CC' is a string literal and not a column name. The engine can now handle this situation properly and determine that CC is indeed a string literal, regardless of how complex the expression involving the Person column.

---

 Resolution

---

Fixed Problem on 11/28/2001 in version 3.04 build 1