using UPPER in the WHERE clause

[nvwildfire]

Has anyone had problems using the UPPER operator in a WHERE clause in a SQL statement in access? I keep getting an error that say "Undefined function 'UPPER' in expression". Here is my query (note I've tried it via ADO and in access query builder):

SELECT tblClassDescription.ClassTitle,
tblClassdescription.ClassDescID
FROM tblClassDescription
WHERE (UPPER(tblClassDescription.ClassTitle) = 'KARLS GIS CLASS')

I may not need to worry about it if the comparison in the WHERE clause is case insensitive?

Any help would be greatly appreciated.

kgk

 

[Maquis]

The where clause may be case insensitive, I'm not sure about that. Give it try and see if it works.

However, I have never heard of the Upper function. I don't think it exists in Access. Looks like you want the Ucase function. Maq
<insert witty signature here>

 

[nvwildfire]

Maquis,

that was my problem (using UPPER instead of UCase). I was using UPPER based on an SQL book I have, it is usally good at saying what works with what based on ANSI SQL standards, but they missed this one. Thanks for your help.

kgk

 

[swampBoogie]

Upper is ANSI. Ucase is not.