I'm having trouble dusting off the cob webs in my mind for query
searches.  I have a detail set with a 26 character field.  A second
field is 4 characters in length.
The records I'm looking for have the following info:

First Field:
bytes 1-6 = "UPSRED"
bytes 7-22 are blank
bytes 23-26 = "nnnnn"  ( I need to find all records with UPSRED)

Second Field:
bytes 1-2 = "10"
byte   3    = "n"  (0 thru 9)
byte   4  is blank

How do I search for all records with UPSRED and a numeric string in
23-26  in field 1 and 10n in bytes 1-3 of field number 2.  Everything
I've tried returns an error

BTW;  these fields are not key search fields.

thanks in advance,


--
Larry Barnes
Director of MIS
Mitek Corp.
4545 E. Baseline Rd.
Phoenix, AZ 85040
[log in to unmask]