>> ... is it proper to allow column names with spaces ... You can do it in SQLite: "my column" or [my column] or 'my column'. The double quotes are allowed by SQL92 as "aids for transitioning from ISO/IEC 9075:1989 to this International Standard", and if I understand correctly, only in weak implementations (entry level). The brackets are a Microsoft extension. I don't know where the single quotes came from.
I think the main reason for allowing these is to help someone who might already have written dozens or hundreds of queries that he wants to port to SQLite. IMHO, they're not 'proper' for new code, but I'm sure someone will disagree. Regards --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
