Table Filter Question

[Anthony]

I have a table that has access tasks assigned to it by 1 and 0. I have a
seq. of
1001000000001000111 and I want to filter all to list every record that has
a 1 in the fourth line. I tried using *, for example all I got was
***1************, but that gave me every record. Is there any way to get
this done.

Thanks

 

[pietlinden]

I have a table that has access tasks assigned to it by 1 and 0.  I havea
seq. of
1001000000001000111   and I want to filter all to list every record that has
a 1 in the fourth line.  I tried using *, for example all I got was
***1************, but that gave me every record.  Is there any way to get
this done.  

Thanks

mid(StrBits,4)=1

 

[John W. Vinson]

I have a table that has access tasks assigned to it by 1 and 0. I have a
seq. of
1001000000001000111 and I want to filter all to list every record that has
a 1 in the fourth line. I tried using *, for example all I got was
***1************, but that gave me every record. Is there any way to get
this done.

Thanks

* means any string of characters (zero to huge). ? as a wildcard means any
single character. Try

LIKE "???1*"

as a criterion.