renee,
unless you're looking to do this frequently rather than a one-off (the
residential stuff) i'd suggest doing a select query which gets all records
containing "residential", and then updating the field of all returned
records so that it reads "RES".
try something like this:
########
Select * from MyTable where FieldName like "%" + "residential" + "%"
into ResidentialStuff
########
that will put anything that has residential in your field into a new
query/table.
then this will update that stuff so that no matter what was in the field, it
will now just read "RES"
########
Update ResidentialStuff Set FieldName = "RES"
########
that should get you going.
not sure about the table>append stuff.
ash
-----Original Message-----
From: Gerasimtchouk, Renee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 18 December 2002 10:25 AM
To: [EMAIL PROTECTED]
Subject: MI-L Search and Replace whole string
Hi all-
I'm looking a search and replace tool that searches a string for one word,
such as 'residential' , and if it finds the word within that string, to
replace the whole string with the word 'RES' and not just the word.
Any ideas?
Also, was wondering about Table>Append Rows to Table. I had two tables with
common fields and duplicates only in one field. When I Appended one table to
the other, it looks as if it deleted the duplicates. Is this the case with
Table>Append? Keep in mind just one field had duplicates and the other
fields were unique.
TIA.
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 4589
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 4590
