how to display a column in a query when the column name is 'desc' ? RRS feed

  • Question

  • I have a table with a column name of 'desc' and am getting an incorrect syntax when attempting to display it as an output column. 

    any help is appreciated,

    Friday, March 9, 2007 6:13 PM


  • You could use square brackets:

    select [desc] from ....

    Friday, March 9, 2007 6:24 PM