Avatar of MikeMCSD
MikeMCSD
Flag for United States of America asked on

Replace a string based on a value in another field

I want to update the FullDescription field based on a value in the Name field :

SELECT Name
FROM  Nop_Product
WHERE (Name LIKE '%(MEN)%')    :

ACQUA DI PARMA by Acqua di Parma (MEN) COLOGNE SPRAY 3.4 OZ

FullDescription field :

<strong>ACQUA DI PARMA by Acqua di Parma</strong> - <span style='font-size:15px;'>Genuine Brand Name Perfume</span><p style='font-size:18px;color:black;padding-top:10px;padding-bottom:10px;'>COLOGNE SPRAY 3.4 OZ</p>Gender : MEN<br /><br />Brand : ACQUA DI PARMA<br /><br />Designer : Acqua di Parma<br /><br />Fragrance : rosemary, citrus, lavender

I want to replace the string : 'Genuine Brand Name Perfume' in FullDescription
with                                       'Genuine Brand Name Fragrance'

WHERE the string '(MEN)' is in the field 'Name'


UPDATE [Nop_Product]
SET  FullDescription =

 WHERE

What's the best way to do this? thanks
Microsoft SQL ServerMicrosoft SQL Server 2008Microsoft SQL Server 2005

Avatar of undefined
Last Comment
MikeMCSD

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
dqmq

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
MikeMCSD

ASKER
thanks
Your help has saved me hundreds of hours of internet surfing.
fblack61