Unless I am missing something, I don't think your example will get me what
I want. What I want to do is match where, for example, the fourth byte in a
field is anything *except* a blank. The ? will match anything, including
blanks, and the b will only match blanks.

Your example will match anything where byte 6 is only the letter "C" and
bytes 7-11 are only blanks.

t 02:29 PM 6/15/2001 -0600, Curt Brimacomb wrote:
>you can use the match command like this:
>
>find name match "?????Cbbbbb"
>
>the ? is a wildcat character, the b is a blank.
>
>
>-----Original Message-----
>From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
>Behalf Of Tom Brandt
>Sent: Friday, June 15, 2001 14:09
>To: [log in to unmask]
>Subject: Pattern matching in Query
>
>
>Is it possible, using pattern matching in Query, to find records where a
>particular character postion in a field does not contain a particular
>character, such as a blank?
>

--------------------------------
Tom Brandt
Northtech Systems, Inc.
313 N. 1st Street
Ann Arbor, MI 48103
http://www.northtech.com/

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *