Archives of the TeradataForum

Message Posted: Thu, 11 May 2006 @ 16:57:28 GMT

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

Can someone provide me syntax for a valued CASE expression with LIKE operator?

I am looking for something like

     sel  case a
     when like '%app%' Then Apple
     When like '%mic%' Then Microsoft
     END case.

Thanks,

Naveen.

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