Re: a search and replace query
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 29 Jan 2008 20:34:37 -0700
On Tue, 29 Jan 2008 18:59:00 -0800, Southern at Heart
<SouthernatHeart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I need a simple update query to find the & sign and replace it with {and}
...the & sign gives trouble on down the road. Can someone please show me how
to do this in a query? I know it should be hard, but my brain seems froze!
thanks.
oh, my table I'm searching is tblContacts and the field is HomeAddressStreet
thanks kindly.
UPDATE tblContacts
SET HomeAddressStreet = Replace([HomeAddressStreet], "&", "{and}")
WHERE HomeAddressStreet LIKE "*[&]*";
should do it.
John W. Vinson [MVP]
.
- Prev by Date: RE: Event Procedure
- Next by Date: Re: a search and replace query
- Previous by thread: Re: Cannot choose a record from a combo box
- Next by thread: Re: a search and replace query
- Index(es):
Relevant Pages
|
