Filtering of records in a form based on real type of field

Hi ,

I have an issue with filtering of records on a form (which I am trying to add in executequery of the form datasource) based on real type of field which is of array type.

My requirement is
I have a field say field1 (real type) which is of array type.(i.e I have fields as
field1(0), field1(1), field1(2), field1(3), field1(4) )
I have records in the table as

Record1 15 20 45 0 0
Record2 2 5 6 5 8
Record3 0 0 0 0 0
Record4 0 0 0 4 5
Record5 0 0 0 0 0
(The values above are values of field(0) ,field(1) ,field(2) ,field(3) ,field(4) respectively)

Now I want only those records in the form which have values of any of the fields field(0) ,field(1) ,field(2) ,field(3) ,field(4) to be non-zero (for the above example only record1 , record2 and record4)
Am trying it out in the executequery method of the datasource but unable to write the query for real type of array field.

Can anybody help me out on this ?