Wildcard with Update

From: "Donn" <Donn@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 1 Jun 2005 12:47:21 -0700

SQL 7.0
Need to replace all
AB 2005-XXX
with
C 2005-YYY
Thinking about the following...but, the '%' is taken as a literal in 'C%-YYY'.
update table
set f1 = 'C%-YYY'
where f1 like 'AB%-XXX'
Thanks,
Don

.

Follow-Ups:
- Re: Wildcard with Update
  - From: Hugo Kornelis

Prev by Date: Re: filtering groups
Next by Date: Re: Rename a primary key column
Previous by thread: Re: filtering groups
Next by thread: Re: Wildcard with Update
Index(es):
- Date
- Thread