%$&*! Spaces in column names!

• somnium7

  Old Hand

  Points: 347

  More actions

  April 27, 2007 at 9:40 am

  #173229

  I have a table where some column names include spaces. I don't like this because the program I'm writing to interface with the DB chokes on the spaces. I cannot change the table in any way either. Sooooo, how can I rename these columns between the table and my program?

  maybe a proc using the TABLE data-type?

  any ideas?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 27, 2007 at 9:52 am

  #702982

  Build a view over the table and access the table from your program through the view.

   

• somnium7

  Old Hand

  Points: 347

  More actions

  April 27, 2007 at 9:59 am

  #702984

  This sounds like a good idea but how do I change [Column Name] to ColumnName?

  [Column Name] AS ColumnName?

• somnium7

  Old Hand

  Points: 347

  More actions

  April 27, 2007 at 10:23 am

  #702997

  Ok I got this. The view is setup and working now. Thanks for the help!

• Jeff Moden

  SSC Guru

  Points: 1004617

  More actions

  April 27, 2007 at 3:42 pm

  #703070

  Great suggestion.  Old gaming trick... if you can't move, "change color".

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)