UPPER and/or UCASE Usage

[Ruslan Zasukhin]

On 9/8/05 2:31 PM, "Milan" <milan at mook.co.uk> wrote:

Hi Milan,

> 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?
>  

What version of Valentina

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]