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

 

[WP]

I would change the object names.

If I need to prefix or suffix a table name I use the underscore character.


Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out my website !

 

[TheInsider]

Anytime you use " ", "/", "("... you should enclose the table or field name in "[" and "]" ie. [My Table(1)].Field

Rob Marriott
rob@career-connections.net