Dynamic Columns and WHERE clause

• BillyWilly

  SSCrazy

  Points: 2304

  More actions

  January 31, 2003 at 10:15 am

  #80683

  Hello... Been awhile...

  If I have this - all works fine:

  Select

  'ANormalColumn',

  CASE

  WHEN 1 = 1 THEN 'T'

  ELSE 'F'

  END AS ADynamicColumnName

  Then if I add this - failure with "Invalid Column Name":

  WHERE

  ADynamicColumnName != 'F'

  What's the deal here?

• jpipes

  SSChampion

  Points: 12230

  More actions

  January 31, 2003 at 11:17 am

  #447735

  You will have to either:

  a) include the case expression's switch field in the where clause, or

  b) put the whole select in a derived table then build a where expression on the derived table's alias:

  SELECT * FROM

  (

  Select

  'ANormalColumn',

  CASE

  WHEN 1 = 1 THEN 'T'

  ELSE 'F'

  END AS ADynamicColumnName

  ) as dt

  where dt.ADynamicColumnName = 'F'