Sorry for hijacking the topic but, i need to select a varchar(30) as
char(1), should i use cast?

The reason is that i have a config table that have 2 fields (config and
value) and some configs will be always "Y" or "N", so can i use cast in this
case?

thanx,

-Fábio.

On 8/3/06, Rick Debay <rdebay@...> wrote:
>
> Doh! I'm blaming the head cold...
>
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com<firebird-support%40yahoogroups.com>
> [mailto:firebird-support@yahoogroups.com<firebird-support%40yahoogroups.com>]
> On Behalf Of Alexandre Benson
> Smith
> Sent: Wednesday, August 02, 2006 6:35 PM
> To: firebird-support@yahoogroups.com <firebird-support%40yahoogroups.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
>
>
>


[Non-text portions of this message have been removed]