Doh! I'm blaming the head cold...

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Alexandre Benson
Smith
Sent: Wednesday, August 02, 2006 6:35 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] CAST doesn't work in SELECT

Rick Debay wrote:

> A simple example is
>
> SELECT
> (CAST (d.RDB$RELATION_ID) AS DOUBLE) FROM
> RDB$DATABASE d
>

select cast(RDB$RELATION_ID as double precision) from rdb$database

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br