From: esquel@sommarskog.se   
      
   chris H (chris.sjpd@gmail.com) writes:   
   > WITH   
   > (   
   >     AccidentReportNumber-AllPages varchar(20),   
   >     AddressFullText varchar(100) '/trafficunit/driver',   
   >     InjuredWas_driver int '/involvedPeople',   
   >     PedestrianActionA-AllPages int,   
   >     MotorVehicleInvolvedWithC-AllPages int,   
   >     CollisionOccurredDate-AllPages  date,   
   >     Time-AllPages  int   
   > )   
   >   
   >   
   > Here is the error:   
   > Msg 102, Level 15, State 1, Line 32   
   > Incorrect syntax near '-'.   
   >   
      
   The name you have to the left is a column name, and must follow the regular   
   syntax for identifiers. Hyphen is not a permitted character in an   
   identifier.   
      
   You need to wrap these names in double quotes or bracket. These delimiters   
   permits you to have about any column name.   
      
   For instance:   
      
   [PedestrianActionA-AllPages] int,   
   "MotorVehicleInvolvedWithC-AllPages" int,   
      
   "" and[] are equivalent. "" is the ANSI standard. [] is the Microsoft way.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)