[SQL]Update command with space in table name

[Francois Van Lerberghe]

Hello,

I'm just testing the update command and it doesn't seem to work when the
table name or the field name has space in it. Is there some special syntax
or is it a bug ?

UPDATE myTable SET myField='test' WHERE myField='wrong'          => OK
UPDATE [my Table] SET [my Field]='test' WHERE [my Field]='wrong' => not OK

Thank you for your help.

François Van Lerberghe
Thier Monty, 15A
B-4570 Marchin
Belgique