Archives of the TeradataForum

Message Posted: Mon, 11 Nov 2002 @ 16:58:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Jim:

Try this:

SELECT (CASE
    WHEN Al1.Itin_Cmpmt_Cd = 'C' OR Al1.Itin_Cmpmt_Cd ='F'
      THEN  'P'
      ELSE 'E'
  END  ) (CHAR(1)) (title ' "Cabin_Class" ')

	<Prev	Next>		<<First	<Prev	Next>	Last>>