Re: Replacing Content

2001-02-20 Thread Ed Carp
Marcus Ouimet ([EMAIL PROTECTED]) writes: > I am trying to figure out how to change content using wildcards. Something > like: > > if the data in the field "date" in the table products equals 2001*.* change > to 200100 "update products set date='200100' where date like '2001%'" should w

Replacing Content

2001-02-20 Thread Marcus Ouimet
I am trying to figure out how to change content using wildcards. Something like: if the data in the field "date" in the table products equals 2001*.* change to 200100 Any help/direction is appreciated. Thanks in advance.