SQL UDF Example - Bit manipulation

Wed, 01/07/2009 - 21:32 |  hdanzl
0

Functions syntax..

 BITAND(  Value1, Value2)
 BITOR(  Value1, Value2)
 BITXOR(  Value1, Value2)
 BITNOT(  Value )
 BITSET(  Value, Bit)
 BITGET(   Value,  Bit )

NexusDB would like to thank
Keith Johnson for providing this example.

How to use?: 

To use -> Just add unit to projects DPR, this includes C/S if you recomiple nxServer with it.

Example:

select BitAND(intField1, intField2) from atable;

Category: 
SQL Functions & Procedures
Current Version: 
1.00
Supported Products: 
NexusDB V2
NexusDB V3
AttachmentSize
SQL UDF.ZIP2 KB
Login or register to post comments |  Print this chapter |  Send to friend |  PDF version |  metadata Tags:
Home

Powered by Drupal and Drupal Theme created with Artisteer.