Hi Tom

You can not use Query or I do not know any way to do this function in
QUERY.

However if you can take dataset away for may be 5-10 min depending on size
of the dataset, you can use SUPRTOOL and QEDIT to get the result you want.

1. Extract (Delete) all records from the dataset with matching pattern.
2. Change string "UFD" with "uF" in QEDIT
3. PUT back to change data.

When I do these type of job, I also make copy of data before, and after the
change and RUN COMPARE just to make sure that I have not change any other
field.

HTH

Jagdish Damania
408-563-1490





 (Embedded
 image moved   Tom Brandt <tbrandt @ NORTHTECH.COM>
 to file:      09/11/98 08:34 AM
 pic10766.pcx)




Please respond to Tom Brandt <[log in to unmask]>

To:   HP3000-L @ RAVEN.UTC.EDU
cc:    (bcc: Jagdish Damania/APPLIED MATERIALS)
Subject:  Re: Query Variable use in search and replace





At 09:37 9/11/98 -0500, Mark Gross wrote:
>maybe I'm using the wrong tool here, but has anyone found a way using
Query
>to replace a image field value
>that requires use of a variable? The following example shows what I want
to
>do.
>
>1. find all occurrences of the substring "UFD" in the 60 character field
>EXTDESC
>2. change "UFD" to "uF"
>
>
>
>Mark Gross
>Emerson Motion Control
>[log in to unmask]
>

Using Query, you can find occurences of a substring using pattern matching:

FIND EXTDESC MAT "?*UFD?*"

However, you cannot change a substring.  The REPLACE command operates on
the entire field.


Tom Brandt                            Northtech Systems, Inc.
+1 734-769-5040                     3588 Plymouth Road, Suite 292
+1 734-769-5498 (FAX)            Ann Arbor, MI 48105