UPPER and/or UCASE Usage

Milan milan at mook.co.uk
Thu Sep 8 12:31:31 CDT 2005


Hi,
 
I can't get the following (valid) SQL statement to work with Valentina:
 
SELECT * FROM schools WHERE upper(name) LIKE '%PAT%'
 
The problem is caused by the "upper" function. What do I need to change to
achieve the same result?
 
Cheers,
 
milan.


More information about the Valentina mailing list