Archives of the TeradataForum

Message Posted: Thu, 11 May 2006 @ 18:53:41 GMT

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

The "valued" CASE syntax always implies a test for equality. If you want to use the LIKE operator you must use "searched" CASE:

     select case
     when a like '%app%' Then 'Apple'
     when a like '%mic%' Then 'Microsoft'
     end ...

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