How to perform simple bit-wise operations like OR (|), AND (&), XOR (^) in SQL queries?
Can these be performed on numeric values? like
sel 1 | 2;
|
|
|
|
|
|
|
Teradata doesn't have bitwise operations out of the box. However if you can install a UDF pack, check out the Teradata UDFs for Byte Operations package. Also, it is possible to do bit operations with the help of a table of powers of 2. Something like this:
|
|||
|