select columns by mask...

• prodigychild

  SSC Rookie

  Points: 26

  More actions

  February 20, 2003 at 2:51 am

  #81508

  Hi to everyone,

  Can u please tell me if it's possible to do select of the columns by mask in t-sql. Let's say I have 10 column's in temp table and want to exlude one of them.

  Thanx in advance,

  PC

• jpipes

  SSChampion

  Points: 12230

  More actions

  February 20, 2003 at 7:32 am

  #449357

  Just list the columns you do want to display in the SELECT clause.