UPPER and/or UCASE Usage

[Ivan Smahin]

Hello Milan,

Thursday, September 8, 2005, 2:31:31 PM, you wrote:

M> I can't get the following (valid) SQL statement to work with Valentina:
 
M> SELECT * FROM schools WHERE upper(name) LIKE '%PAT%'
 
M> The problem is caused by the "upper" function. What do I need to change to
M> achieve the same result?
 
I've checked the same query using VStudio, and it works fine.
So, could you please give us more info.

1. What kind of field do you use?
2. Is field Indexed or not?
3. Any collation attribute applied to the database?



-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua