Yes

The new rule is that if you create an alias (Stock S) then you cant use
the table name as well. So

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

is Ok

so is

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

and so is

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


I hope that explains it. Im sure there are others who could explain it better than I.

Rob




--
Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Sergio H. Gonzalez wrote:

> 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]
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>