Guten Tag Si Carter,

am Mittwoch, 14. Dezember 2005 um 10:24 schrieben Sie:

>> -----Original Message-----
>> I have a 64 bit integer and I need to zero out the least significant
>> 32 bits and use the resulting value. How do I do this in firebird ?

> You will probably need to create a UDF.

Why ?
Integer Divide and Multiply

select (1000 / 64 ) *64 from table ;

substitue 64 with the Value of 2^32+1





--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...