characters in SQL

[rhintintin]

I have queries and tables with the characters ( ) and / in them, but when you write a SQL it gets all confused and starts to give error messages, can this be stopped or do i have to rename all my queries etc... this is really bugging me cos if you can have queries and table names with these characters in why does SQL get in such a stress

cheers

 

[culshaja]

In SQL the () characters are used to delimit fields etc, or in the case of column names it thinks they are functions. There is nothing that I know of that you can do about this, unless you put [] around the table names. This works in SQL to note that it is either a table or column name rather than a fubction name. That might work.

James

James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305