Member
Posted 21 June 2013 - 03:12 PM
CASE lin_edad
When 25 Then lin_porcentaje:= 10;
When 30 Then lin_porcentaje:= 15;
When 35 Then lin_porcentaje:= 17;
Else lin_porcentaje:= 5;
END CASE;
missing my father, I love my mother.
Posted 21 June 2013 - 03:53 PM
CASE lin_edad
WHEN 25 THEN 10
WHEN 30 THEN 15
WHEN 35 THEN 17
ELSE 5
END AS lin_porcentaje
CASE @TestVal
WHEN 1 THEN 'First'
WHEN 2 THEN 'Second'
WHEN 3 THEN 'Third'
ELSE 'Other'
END
Member
Posted 21 June 2013 - 05:23 PM
