On 1/31/07, 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.
Since SQLite has no datatypes, char(3) doesn't mean anything to it. How about SELECT null AS CDRefIndustry or SELECT '' AS CDRefIndustry
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 5:14 PM To: [email protected] Subject: Re: [sqlite] Equivalent syntax? "Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote: > What's the equivalent sqlite syntax for sybase convert function? Can you describe what the convert function in sybase does? That might help us to find the equivalent function in SQLite for you. -- 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] -----------------------------------------------------------------------------
-- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
