BITAND Function | VantageCloud Lake - BITAND - Teradata Vantage

Performs the logical AND operation on the corresponding bits from the two input arguments.

This function takes two bit patterns of equal length and performs the logical AND operation on each pair of corresponding bits. If the bits at the same position are both 1, then the result is 1; otherwise, the result is 0. If either input argument is NULL, the function returns NULL.

• BITAND Function Syntax
• BITAND Argument Types and Rules
• BITAND Result Type and Attributes
• Examples: Querying with the BITAND Function

For more information about target_arg and bit_mask_arg, see Performing Bit-Byte Operations against Arguments with Unequal Lengths.

See also "Function Name Overloading" in Using Functions with CREATE/REPLACE FUNCTION (SQL Form).

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.