UPPER and/or UCASE Usage

[Milan]

I'm running V2, more specifically V4MD_205fc15_win.exe. 

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
Sent: 08 September 2005 12:54
To: valentina at lists.macserve.net
Subject: Re: UPPER and/or UCASE Usage

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]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina