Is cast documented on the sqlite website? I couldn't find it.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 31, 2007 5:51 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Equivalent syntax?
"Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote:
> In the case shown, for example,
>
> convert(char(3), NULL) CDRefIndustry,
>
> It creates a char(3) column, sets it to null, and names it
> CDRefIndustry.
>
Dennis Cote's guess was mostly right then. A strict equivalent
in SQLite (and in standard SQL) would be:
cast(NULL AS char(3)) CDRefIndustry
But the cast is not really necessary in SQLite. You could
get by with just this:
NULL CDRefIndustry
So, tell me James, what is MorganStanley doing with SQLite? ;-)
--
D. Richard Hipp <[EMAIL PROTECTED]>
------------------------------------------------------------------------
-----
To unsubscribe, send email to [EMAIL PROTECTED]
------------------------------------------------------------------------
-----
--------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does not
intend to waive confidentiality or privilege. Use of this email is prohibited
when received in error.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
