CASE
WHEN left("clc06",3)= '141' THEN 0
WHEN left("clc06",3)= '142' THEN 0
WHEN left("clc06",3)= '211' THEN 0.4
WHEN left("clc06",3)= '212' THEN 0.4
WHEN left("clc06",3)= '213' THEN 0.6
WHEN left("clc06",3)= '221' THEN 0.8
WHEN left("clc06",3)= '222' THEN 0.7
WHEN left("clc06",3)= '223' THEN 1
WHEN left("clc06",3)= '241' THEN 0.7
WHEN left("clc06",3)= '242' THEN 1
WHEN left("clc06",3)= '231' THEN 0.75
WHEN left("clc06",3)= '243' THEN 1
WHEN left("clc06",3)= '321' THEN 1
WHEN left("clc06",3)= '322' THEN 0.8
WHEN left("clc06",3)= '323' THEN 0.8
WHEN left("clc06",3)= '324' THEN 0.6
WHEN left("clc06",3)= '243' THEN 0.6
WHEN left("clc06",3)= '244' THEN 0.6
WHEN left("clc06",3)= '311' THEN 1
WHEN left("clc06",3)= '312' THEN 1
WHEN left("clc06",3)= '313' THEN 1
WHEN left("clc06",3)= '411' THEN 1
WHEN left("clc06",3)= '412' THEN 0.8
WHEN left("clc06",3)= '421' THEN 0.8
WHEN left("clc06",3)= '422' THEN 0.8
WHEN left("clc06",3)= '423' THEN 1
WHEN left("clc06",3)= '511' THEN 1
WHEN left("clc06",3)= '512' THEN 1
END