Sorry, I was a little bit unclear. My problem is that I have the need to treat "table1" and "TABLE1" as two single entities.
ivo -----Ursprüngliche Nachricht----- Von: Austin Ziegler [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 28. September 2005 16:21 An: sqlite-users@sqlite.org; [EMAIL PROTECTED] Betreff: Re: [sqlite] Case-sensitive table names On 9/28/05, Ivo Kulms <[EMAIL PROTECTED]> wrote: > Hi there, > > Is it possible in sqlite to work with case-sensitive table- and column > names? > > (Sorry if this has been already answered somewhere in the > documentation, but I did not seem to find it.) Fortunately, sqlite is (mostly) standards based and if you want this particular abomination, you put your table and column names in double quotes. SELECT "SillyColumn" FROM "SillyTable" -austin -- Austin Ziegler * [EMAIL PROTECTED] * Alternate: [EMAIL PROTECTED]
