Thomas, all,

You're right! The problem was with my 'Group By' clause.

Thank you all for your quick replies!

Best regards,

Arno Rog


--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:

> Hi Arno,
>
> > Thank you for your reply.
> > According to the Embedded SQL Guide page 125 CAST() can be used
> > to 'convert' NUMERIC to CHARACTER only, not vice versa. Testing
> > confirms this, CAST(R_DATETOSTR(ordlog.MUTTIMESTAMP, '%W') AS
> > SMALLINT) returns nothing.
> >
> > I hope someone else can help me.
>
> Try:
>
> select cast('1' as SMALLINT) from rdb$database
>
> As you will see, it works.
>
> Perhaps ordlog.MUTTIMESTAMP allows NULLs?
>
>
> Thomas