OK, thanks, I'll try that. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: Wednesday, January 31, 2007 5:34 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Equivalent syntax?
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: sqlite-users@sqlite.org > 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] ------------------------------------------------------------------------ ----- -------------------------------------------------------- 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] -----------------------------------------------------------------------------
