considering a table named as - 'table_name'
and having columns- 'Patient_Type', 'Patient_ID'
i will suggest the following solution
select
result=case Patient_Type
when 'Normal' then 'ln0000'+Patient_ID
when 'LAMA' then 'L0000'+Patient_ID
end
from table_name
Please check and mask as answer if it works.