You can try



SELECT
S.ID,
S.DESCRIPCION
FROM
STOCK S
WHERE
UPPER(S."DESCRIPCION") STARTING WITH 'CPU'



Regards,

Paul





From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Sergio H. Gonzalez
Sent: 30 May 2008 00:23
To: firebird-support@yahoogroups.com
Subject: [firebird-support] upgrade to v2.1 -> Column unknown



Hello, I'm curious about this... I've just upgraded from v1.5 to 2.1 and
this simple query that use to run, now gives an error.

SELECT
S.ID,
S.DESCRIPCION
FROM
STOCK S
WHERE
UPPER("STOCK"."DESCRIPCION") STARTING WITH 'CPU'

Column unknown.
STOCK.DESCRIPCION.

Was the previous behaviour wrong?

Thanks!

-sergio

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]