[dbo].[bit

[dbo].[bit_and]

(local) > mdb > Scalar-valued Functions > dbo.bit_and

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@num	binary(8000)	8000
@num2	binary(8000)	8000

SQL Script

/****** Object:  User Defined Function dbo.bit_and    Script Date: 12/1/2005 11:50:33 PM ******/

CREATE FUNCTION [dbo].[bit_and](@num binary(8000), @num2 binary(8000) )
RETURNS varbinary(8000) AS
BEGIN
     RETURN convert(varbinary(8000), (convert(int, @num) & convert(int, @num2)))
END
GO

Uses