2 Replies Latest reply on Jan 25, 2007 5:56 AM by Newsgroup_User

    Can it be done?

    Level 7
      I am attempting to use a column as a conditional, but my DBA upsized an old
      Access application that used unorthodox naming method for the columns
      ('confirmation sent', 'invited?', etc)and then prodeded to write a bunch of
      MSSQL Views off of them. Unfortunetly for me, MSSQL doesn't autoupdate when
      the Views information when you rename the columns.

      OK, I told you all that to ask you this. How can I get something like this
      to work (with the space in it)

      #GetAccepted.[confirmation sent]#

      I keep getting an error with the '#' because of the brackets and I can't
      remove the space or the who backend will fall out.

      Any ideas?