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