Subject Re: [firebird-support] The use of Stored Procedures
Author Nando Dessena
I wrote:

N> select
N> T.*,
N> (select WEEK_NO from WEEK_OF_YEAR(T.DATEFIELD) WEEK
N> from TABLE T

third line lacks a bracket.

(select WEEK_NO from WEEK_OF_YEAR(T.DATEFIELD)) WEEK

Ciao
--
Nando Dessena
mailto:nandod@...