Javier Chávez B. escribió:
> UPDATE ttamlice SET licservicio = '02' WHERE liccateg in( '04','05','06')
> UPDATE ttamlice SET licservicio = '03' WHERE liccateg in( '01','02','03')
Mejor todavia:
update ttamlice set licservicio = case
when liccateg in ('04', '05', '06') then '02'
when liccateg in ('01', '02', '03') then '03'
end
where liccated in ('01, '02', '03', '04', '05', '06')
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 48' 55.3", W 73º 15' 24.7"
"Digital and video cameras have this adjustment and film cameras don't for the
same reason dogs and cats lick themselves: because they can." (Ken Rockwell)
--
TIP 3: Si encontraste la respuesta a tu problema, publícala, otros te lo
agradecerán
