DECODE Statement

DECODE Statement

• mark87544

  You can also use it to have any expression in the WHEN section i.e.

  CASE WHEN col1='Fred' THEN 'SIMON'

  WHEN col2='Smith' THEN 'Jo

  END

  which means its very flexible. it will only process the THEN for the first WHEN that evaluates to TRUE

  
  
  

• fbrian

  Look in Books On-Line for the CASE statement. You will probably want the simple CASE format. Here is an example from there:

  CASE type
  WHEN 'popular_comp' THEN 'Popular Computing'
  WHEN 'mod_cook' THEN 'Modern Cooking'
  WHEN 'business' THEN 'Business'
  WHEN 'psychology' THEN 'Psychology'
  WHEN 'trad_cook' THEN 'Traditional Cooking'
  ELSE 'Not yet categorized'
  END,
  

  
  

• _MRCHINGON_

  Thanks it works fine.

  Regards

  Raimund

  
  
• DECODE Statement