× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Better yet, instead of using an "or"

where '.' in (fld1,fld2,fld3, etc)




--

Michael Schutte
Admin Professional



Bob Evans Holiday Farmhouse Feast, Serves 6-8 l $74.99
A complete homestyle meal TO GO, ready to heat at home, serve & enjoy!
Perfect for Thanksgiving, Christmas or holiday entertaining.
For more information, visit www.FarmhouseFeast.com



midrange-l-bounces@xxxxxxxxxxxx wrote on 03/31/2010 02:15:59 PM:

Of course keeping the WHERE clause as originally proposed, would
limit which rows will be updated, to only those rows which have at
least one of the column values equal to the period.

<code>

update myfile set
( fld01, fld02, fld03,
...
, fld13, fld14, fld15) =
( case fld01 when '.' then ' ' else fld01 end
, case fld02 when '.' then ' ' else fld02 end
, case fld03 when '.' then ' ' else fld03 end
...
, case fld13 when '.' then ' ' else fld13 end
, case fld14 when '.' then ' ' else fld14 end
, case fld15 when '.' then ' ' else fld15 end
)
where
( fld01='.' or fld02='.' or fld03='.'
...
or fld13='.' or fld14='.' or fld15='.'
)

</code>

Regards, Chuck

Michael_Schutte@xxxxxxxxxxxx wrote:
update file set
fld1 = (case fld1 when '.' then ' ' else fld1 end) ,
fld2 = (case fld2 when '.' then ' ' else fld2 end) ,
etc.

this will do an update on every record in the table for every
field, but only when field equals '.' will it actually change.


David FOXWELL wrote:
I can select the records I want to update like this.

Select * from myfile where
field1 = '.' or
field2 = '.' or....
field15 = '.'

There are 15 fields that may contain the value '.'

How can I update any field that contains a '.' to the value ' '
without touching any other fields?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.