Archives of the TeradataForum

Message Posted: Thu, 09 Oct 2003 @ 18:17:34 GMT

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

Does anyone know if Teradata can perform bitwise operations?

I.e. (x & 1) = 1
     (x & 2) = 2
     (x & 4) = 4

I know I can do:

case when x in (1,3,5,7,9) then 1 else 0 end
case when x in (2,3,6,7) then 2 else 0 end
case when x in (4,5,6,7) then 4 else 0 end

but this implies a closed world assumption and it's a little too restrictive for my liking

Thanks,

Jason

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