RE: Table Names need ""

[Ian]

Thanks Elke,   Yep it is now working … thanks for the clarification…   Ian   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Zabach, Elke Sent: mi�rcoles, 09 de octubre de 2002 14:33 To: 'Ian'; [EMAIL PROTECTED] Subject: RE: Table Names need ""   Ian wrote:   > I imported an SQL Server database and data into sap but all my queries > require " (quotes) around the table name and column names.. > > So I figured it out, its because they are mixed case, if I edit the > TABLE names and COLUMN names and put them to upper case it works without problems. > > So I do I change all my tables so that the COLUMN names are are set to UPPER CASE?? > > Please help, getting desperate, I am so close but yet so far, <grin>..... > As written in the reference manual:   Simple identifier  Simple identifier. The first character in a simple identifier must not be a digit or underscore. Syntax <simple_identifier> ::= <first_character>[<identifier_tail_character>...] first_character, identifier_tail_character Explanation Simple identifiers are always converted into uppercase characters in the database. For this reason, simple identifiers are not case sensitive. If the name of a database object is to contain lowercase letters, special characters, or blanks, the identifier must be specified as a special identifier (in double quotes).    -->  If you do not want to use " " around all names, you are not allowed to use them during creation of an object (if you use other character than capital letter and those 3 special character allowed for simple_identifier). Therefore: check how the tables are created and try to avoid using " there.   Elke SAP Labs Berlin