> A cheeseboard for you, Alan. :-)
>
> create table "sunshine" (
> "select" varchar(10),
> "washing day" date);
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 1, char 14
> "sunshine"
>
> d1
> select 10/3 as one_third from rdb$database;
> one_third
> =================
> 3.333333333333333
> (this isn't SQL standard, btw)
>
> d3
> select 10/3 as one_third from rdb$database;
> one_third
> =================
> 3
>
> d1
> select cast(current_timestamp as char(10)) as just_the_date
> from rdb$database
> just_the_date
> ==========
> 7-MAY-2004
>
> d3
> select cast(current_timestamp as char(10)) as just_the_date
> from rdb$database
> ISC ERROR CODE:335544321
>
> ISC ERROR MESSAGE:
> arithmetic exception, numeric overflow, or string truncation
>

Amazing... all things I was taught never to do.. I don't see them as
language enhancements but rather further error checking in the parsing
engine.
Alan