[sqlite] SELECT syntax?

[mike . griffin]

I have a strange problem, I can do this:

UPDATE [Employees] SET
        [EMAIL PROTECTED],
        [EMAIL PROTECTED],
        [EMAIL PROTECTED],
        [EMAIL PROTECTED]
WHERE
        [EMAIL PROTECTED]

But I can do this,

SELECT [LastName],[FirstName] FROM [Employees]

I have to remove the [] brackets on LastName and FirstName in order for it
to work, are [] even allowed?

I'm confused abit.