HP3000-L Archives

June 2001, Week 3

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Pattern matching in Query
From:
Curt Brimacomb <[log in to unmask]>
Reply To:
[log in to unmask]
Date:
Fri, 15 Jun 2001 14:29:14 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (38 lines) 
you can use the match command like this:

find name match "?????Cbbbbb"

the ? is a wildcat character, the b is a blank.

Curt Brimacomb
Systems Manager
Idaho Computer Services, LLC
[log in to unmask]
208-734-2245 x 114
"Never surrender to doubt"

-----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 *

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

ATOM RSS1 RSS2