Re: Search And Replace
From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Thu, 05 Jul 2001 14:08:46 GMT
Message-ID: <Ox_07.2195$Qn3.13082600_at_news2.news.adelphia.net>
Date: Thu, 05 Jul 2001 14:08:46 GMT
Message-ID: <Ox_07.2195$Qn3.13082600_at_news2.news.adelphia.net>
update tablename
set fieldname = 'Member'
where fieldname like 'Member%20';
"Jim Winter" <bravo113_at_lycos.com> wrote in message
news:cFI07.20596$WT.3492579_at_typhoon.austin.rr.com...
> I want to search for a value and replace it if found.
> Example: If Member 20 or Member20, or Member 20 found then "Member"
>
> Any suggestions:
> ander299_at_pilot.msu.edu
>
>
Received on Thu Jul 05 2001 - 16:08:46 CEST