🚀 go-pugleaf

Hi,

I'm redesigning the databasestructure and need 130 boolean values. To
decrease the size of the datastructure I want to use 5 integer fields and
apply bitwise operators. The statement should be something like (it doesn't
work):

  select TrackTitle, Artist
  from track T join Crit1 C
  on (T.DISCID = C.DISCID)
  where ((Extra1 and $00100000) = $00100000)

The operator "and" should here be bitwise instead of logical. Does anyone
have an idea how to use bitwise operaters in a sql-statement or how to call
a external function in the where - clause ?

I use paradox tables in Delphi 4

Thanks in advance

Yves Vermeersch