HomeFlySpeed SQL QueryIs there a way to remove the square brackets from field names?

Is there a way to remove the square brackets from field names?


Hello,
SQL Query is a great tool full of options but I can't find a way to remove square brackets in fields name
Instead of having:

MYTABLE.[MYFIELD]

I'd like to have:

MYTABLE.MYFIELD

Any help, please?
Thanks in advance
Ivan | email
September 27 2009, 07:51 AM
Dear Ivan,

Are there all fields quoted with square brackets or with some specific field names only? Are the table names quoted either? Normally the tool shouldn't quote identifiers if there's no need to do that.
Sergey Smagin | email
1 day, 22 hours since original post
Uhm... they are all in the form MYTABLE .[MY_FIELD] , so with underscore... Maybe this is a reserved or problematic charachter? Honestly I tried other tools before but they didn't wrap so-made column names in square brackets (and they can't compare to FlySpeed SQL Query :-)
Ivan | email
2 days since original post
This topic is closed