Re: Bitwise operators in SQLs/4GLs

Posted in 2004

Obnoxio The Clown — Thu, 24 Jun 2004 12:30:59 +0100 (BST) — source: Usenet: comp.databases.informix

Scott Burns said: > Obnoxio The Clown wrote: > > I agree. For preference, I'd rewrite it to use seperate fields for each > flag. > I mean, it won't even display properly in a perform screen, and the hoops > we > need to jump through for an sql is rediculous. After an hour or so I came > up > with MOD( ROUND( ( ( amdflag / 4 ) - 0.5 ), ), 2 ) = 1 AND MOD( ROUND( > ( ( > amdflag / 2 ) - 0.5 ), ), 2 ) = 1 > > It's not the sort of code I'm going to tell the kids about. I think you should! It's hilarious! -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list