Combine multiple UPDATE statements

[chillay]

Hello

Is there a way to combine the following 3 UPDATE statements to avoid executing each statement one-by-one?

UPDATE ServicePlans
SET PlanName = 'Long Distance (In/Out of State/Country)'
WHERE PlanName = 'Long Distance A';

UPDATE ServicePlans
SET PlanName = 'Long Distance (Limited States)'
WHERE PlanName = 'Long Distance B';

UPDATE ServicePlans
SET PlanName= 'Long Distance (In/Out State)'
WHERE PlanName = 'Long Distance C';

Thank you

 

[DotNetGnat]

i dont think so..the way you have it now is correct...

-DNG

 

[PHV]

And what wrong with 3 statements ?
Anyway:
UPDATE ServicePlans
SET PlanName = IIf(PlanName = 'Long Distance A','Long Distance (In/Out of State/Country)',IIf(PlanName = 'Long Distance B','Long Distance (Limited States)','Long Distance (In/Out State)'))
WHERE PlanName = IN ('Long Distance A','Long Distance B','Long Distance C');

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[chillay]

Thank you guys. You are always so helpful.

Chillay