Creating new table with space in column name

1

Hi,

I’m having an issue with creating new table using custom database command.
I need to create a table with space in its variable name (Project No) and it’s returning an error message that I can’t resolve.

The error message disappears when I tried ‘ProjectNo’ instead - however I need retain the space in the variable/column name.

Could anyone please point me to the right direction on how to fix the issue?

image

2

Hi Mario,

You should use double quotes instead of square brackets to wrap the column names.

1 Like
3

Hi Andrew,

Thank you for the prompt reply - it works like a charm!

4

Mario, you are welcome!