| Subject | RE: [firebird-support] SQL: clear the least signifcant bits in a 64 bit integer |
|---|---|
| Author | Si Carter |
| Post date | 2005-12-14T09:54:35Z |
> -----Original Message-----There you go then. Ive learnt something new :-)
> > 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
Rgds
Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://www.tectsoft.net/ - Homepage