Wildcard with Update

SQL 7.0
Need to replace all
AB 2005-***
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%-***'
Thanks,
Don

Hi Don,

Try if this works:

UPDATE MyTable
SET F1 = STUFF(F1, 1, 2, 'C')
WHERE F1 LIKE 'AB%-***'

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 25th July 07:15 donn External User Posts: 1	Wildcard with Update SQL 7.0 Need to replace all AB 2005-* 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%-*' Thanks, Don

2 25th July 07:15 hugo kornelis External User Posts: 1	Wildcard with Update Hi Don, Try if this works: UPDATE MyTable SET F1 = STUFF(F1, 1, 2, 'C') WHERE F1 LIKE 'AB%-***' Best, Hugo -- (Remove _NO_ and _SPAM_ to get my e-mail address)