Nested case statements

• Prema sambandam

  SSCommitted

  Points: 1825

  More actions

  April 24, 2006 at 9:25 am

  #112590

  Is it possible to write nested case statements. would somebody  please provide a sample statement for that?

  thanks,

  Prema

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  April 24, 2006 at 9:30 am

  #633828

  Yes, it's possible. e.g.

  select

      id,

      case when id between 1 and 7 then

                  case when id = 1 then 'one' when id = 2 then 'two' else 'between three and seven' end

           when id between 8 and 10 then

                  case when id = 8 then 'eight'

                       when id = 9 then 'nine'

                       when id = 10 then 'ten'

                  end

           else 'bigger than ten'

      end as 'pointless description'

  from sysobjects

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.

• Prema sambandam

  SSCommitted

  Points: 1825

  More actions

  April 25, 2006 at 9:19 am

  #634069

  Thanks, I solved my problem